Dataset statistics
| Number of variables | 49 |
|---|---|
| Number of observations | 115609 |
| Missing cells | 176925 |
| Missing cells (%) | 3.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 44.1 MiB |
| Average record size in memory | 400.0 B |
Variable types
| Text | 12 |
|---|---|
| Categorical | 8 |
| DateTime | 8 |
| Numeric | 21 |
customer_state is highly overall correlated with customer_zip_code_prefix | High correlation |
customer_zip_code_prefix is highly overall correlated with customer_state | High correlation |
order_purchase_year is highly overall correlated with order_purchase_year_month | High correlation |
order_purchase_year_month is highly overall correlated with order_purchase_year | High correlation |
payment_value is highly overall correlated with price | High correlation |
price is highly overall correlated with payment_value and 1 other fields | High correlation |
product_height_cm is highly overall correlated with product_volume_cm and 1 other fields | High correlation |
product_length_cm is highly overall correlated with product_volume_cm and 2 other fields | High correlation |
product_volume_cm is highly overall correlated with product_height_cm and 3 other fields | High correlation |
product_weight_g is highly overall correlated with price and 4 other fields | High correlation |
product_width_cm is highly overall correlated with product_length_cm and 2 other fields | High correlation |
seller_state is highly overall correlated with seller_zip_code_prefix | High correlation |
seller_zip_code_prefix is highly overall correlated with seller_state | High correlation |
order_status is highly imbalanced (93.4%) | Imbalance |
seller_state is highly imbalanced (63.2%) | Imbalance |
order_delivered_carrier_date has 1195 (1.0%) missing values | Missing |
order_delivered_customer_date has 2400 (2.1%) missing values | Missing |
review_comment_title has 101808 (88.1%) missing values | Missing |
review_comment_message has 66703 (57.7%) missing values | Missing |
time_to_delivery has 2400 (2.1%) missing values | Missing |
delivery_against_estimated has 2400 (2.1%) missing values | Missing |
review_response_time is highly skewed (γ1 = 24.09891986) | Skewed |
review_response_time has 28066 (24.3%) zeros | Zeros |
delivery_against_estimated has 1468 (1.3%) zeros | Zeros |
order_purchase_hour has 2835 (2.5%) zeros | Zeros |
Reproduction
| Analysis started | 2023-12-12 04:36:43.886772 |
|---|---|
| Analysis finished | 2023-12-12 04:38:10.412497 |
| Duration | 1 minute and 26.53 seconds |
| Software version | ydata-profiling vv4.6.2 |
| Download configuration | config.json |
order_id
Text
| Distinct | 96516 |
|---|---|
| Distinct (%) | 83.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3699488 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 83927 ? |
|---|---|
| Unique (%) | 72.6% |
Sample
| 1st row | e481f51cbdc54678b7cc49136f2d6af7 |
|---|---|
| 2nd row | e481f51cbdc54678b7cc49136f2d6af7 |
| 3rd row | e481f51cbdc54678b7cc49136f2d6af7 |
| 4th row | 128e10d95713541c87cd1a2e48201934 |
| 5th row | 0e7e841ddf8f8f2de2bad69267ecfbcf |
| Value | Count | Frequency (%) |
| 895ab968e7bb0d5659d16cd74cd1650c | 63 | 0.1% |
| fedcd9f7ccdc8cba3a18defedd1a5547 | 38 | < 0.1% |
| fa65dad1b0e818e3ccc5cb0e39231352 | 29 | < 0.1% |
| ccf804e764ed5650cd8759557269dc13 | 26 | < 0.1% |
| c6492b842ac190db807c15aff21a7dd6 | 24 | < 0.1% |
| a3725dfe487d359b5be08cac48b64ec5 | 24 | < 0.1% |
| 465c2e1bee4561cb39e0db8c5993aafc | 24 | < 0.1% |
| 6d58638e32674bebee793a47ac4cbadc | 24 | < 0.1% |
| 68986e4324f6a21481df4e6e89abcf01 | 24 | < 0.1% |
| 5a3b1c29a49756e75f1ef513383c0c12 | 22 | < 0.1% |
| Other values (96506) | 115311 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 232347 | 6.3% |
| b | 232260 | 6.3% |
| 6 | 232183 | 6.3% |
| e | 231974 | 6.3% |
| c | 231513 | 6.3% |
| 3 | 231489 | 6.3% |
| 1 | 231448 | 6.3% |
| 7 | 231435 | 6.3% |
| 8 | 231366 | 6.3% |
| a | 231122 | 6.2% |
| Other values (6) | 1382351 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2311582 | |
| Lowercase Letter | 1387906 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 232347 | |
| 6 | 232183 | |
| 3 | 231489 | |
| 1 | 231448 | |
| 7 | 231435 | |
| 8 | 231366 | |
| 2 | 230768 | |
| 9 | 230559 | |
| 0 | 230074 | |
| 5 | 229913 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 232260 | |
| e | 231974 | |
| c | 231513 | |
| a | 231122 | |
| f | 230865 | |
| d | 230172 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2311582 | |
| Latin | 1387906 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 232347 | |
| 6 | 232183 | |
| 3 | 231489 | |
| 1 | 231448 | |
| 7 | 231435 | |
| 8 | 231366 | |
| 2 | 230768 | |
| 9 | 230559 | |
| 0 | 230074 | |
| 5 | 229913 |
Latin
| Value | Count | Frequency (%) |
| b | 232260 | |
| e | 231974 | |
| c | 231513 | |
| a | 231122 | |
| f | 230865 | |
| d | 230172 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3699488 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 232347 | 6.3% |
| b | 232260 | 6.3% |
| 6 | 232183 | 6.3% |
| e | 231974 | 6.3% |
| c | 231513 | 6.3% |
| 3 | 231489 | 6.3% |
| 1 | 231448 | 6.3% |
| 7 | 231435 | 6.3% |
| 8 | 231366 | 6.3% |
| a | 231122 | 6.2% |
| Other values (6) | 1382351 |
customer_id
Text
| Distinct | 96516 |
|---|---|
| Distinct (%) | 83.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3699488 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 83927 ? |
|---|---|
| Unique (%) | 72.6% |
Sample
| 1st row | 9ef432eb6251297304e76186b10a928d |
|---|---|
| 2nd row | 9ef432eb6251297304e76186b10a928d |
| 3rd row | 9ef432eb6251297304e76186b10a928d |
| 4th row | a20e8105f23924cd00833fd87daa0831 |
| 5th row | 26c7ac168e1433912a51b924fbd34d34 |
| Value | Count | Frequency (%) |
| 270c23a11d024a44c896d1894b261a83 | 63 | 0.1% |
| 13aa59158da63ba0e93ec6ac2c07aacb | 38 | < 0.1% |
| 9af2372a1e49340278e7c1ef8d749f34 | 29 | < 0.1% |
| 92cd3ec6e2d643d4ebd0e3d6238f69e2 | 26 | < 0.1% |
| 6ee2f17e3b6c33d6a9557f280edd2925 | 24 | < 0.1% |
| d22f25a9fadfb1abbc2e29395b1239f4 | 24 | < 0.1% |
| 63b964e79dee32a3587651701a2b8dbf | 24 | < 0.1% |
| 2ba91e12e5e4c9f56b82b86d9031d329 | 24 | < 0.1% |
| 86cc80fef09f7f39df4b0dbce48e81cb | 24 | < 0.1% |
| be1c4e52bb71e0c54b11a26b8e8d59f2 | 22 | < 0.1% |
| Other values (96506) | 115311 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 231848 | 6.3% |
| f | 231815 | 6.3% |
| 5 | 231684 | 6.3% |
| c | 231607 | 6.3% |
| 6 | 231574 | 6.3% |
| 1 | 231546 | 6.3% |
| e | 231206 | 6.2% |
| 8 | 231191 | 6.2% |
| a | 231174 | 6.2% |
| d | 231155 | 6.2% |
| Other values (6) | 1384688 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2311390 | |
| Lowercase Letter | 1388098 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 231848 | |
| 5 | 231684 | |
| 6 | 231574 | |
| 1 | 231546 | |
| 8 | 231191 | |
| 9 | 231116 | |
| 3 | 231114 | |
| 7 | 231035 | |
| 4 | 230174 | |
| 0 | 230108 |
Lowercase Letter
| Value | Count | Frequency (%) |
| f | 231815 | |
| c | 231607 | |
| e | 231206 | |
| a | 231174 | |
| d | 231155 | |
| b | 231141 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2311390 | |
| Latin | 1388098 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 231848 | |
| 5 | 231684 | |
| 6 | 231574 | |
| 1 | 231546 | |
| 8 | 231191 | |
| 9 | 231116 | |
| 3 | 231114 | |
| 7 | 231035 | |
| 4 | 230174 | |
| 0 | 230108 |
Latin
| Value | Count | Frequency (%) |
| f | 231815 | |
| c | 231607 | |
| e | 231206 | |
| a | 231174 | |
| d | 231155 | |
| b | 231141 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3699488 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 231848 | 6.3% |
| f | 231815 | 6.3% |
| 5 | 231684 | 6.3% |
| c | 231607 | 6.3% |
| 6 | 231574 | 6.3% |
| 1 | 231546 | 6.3% |
| e | 231206 | 6.2% |
| 8 | 231191 | 6.2% |
| a | 231174 | 6.2% |
| d | 231155 | 6.2% |
| Other values (6) | 1384688 |
order_status
Categorical
IMBALANCE 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| delivered | |
|---|---|
| shipped | 1138 |
| canceled | 536 |
| invoiced | 358 |
| processing | 357 |
| Other values (2) | 10 |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.9757631 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1037679 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | delivered |
|---|---|
| 2nd row | delivered |
| 3rd row | delivered |
| 4th row | delivered |
| 5th row | delivered |
Common Values
| Value | Count | Frequency (%) |
| delivered | 113210 | |
| shipped | 1138 | 1.0% |
| canceled | 536 | 0.5% |
| invoiced | 358 | 0.3% |
| processing | 357 | 0.3% |
| unavailable | 7 | < 0.1% |
| approved | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| delivered | 113210 | |
| shipped | 1138 | 1.0% |
| canceled | 536 | 0.5% |
| invoiced | 358 | 0.3% |
| processing | 357 | 0.3% |
| unavailable | 7 | < 0.1% |
| approved | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 342565 | |
| d | 228455 | |
| i | 115428 | 11.1% |
| l | 113760 | 11.0% |
| v | 113578 | 10.9% |
| r | 113570 | 10.9% |
| p | 2639 | 0.3% |
| s | 1852 | 0.2% |
| c | 1787 | 0.2% |
| n | 1258 | 0.1% |
| Other values (6) | 2787 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1037679 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 342565 | |
| d | 228455 | |
| i | 115428 | 11.1% |
| l | 113760 | 11.0% |
| v | 113578 | 10.9% |
| r | 113570 | 10.9% |
| p | 2639 | 0.3% |
| s | 1852 | 0.2% |
| c | 1787 | 0.2% |
| n | 1258 | 0.1% |
| Other values (6) | 2787 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1037679 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 342565 | |
| d | 228455 | |
| i | 115428 | 11.1% |
| l | 113760 | 11.0% |
| v | 113578 | 10.9% |
| r | 113570 | 10.9% |
| p | 2639 | 0.3% |
| s | 1852 | 0.2% |
| c | 1787 | 0.2% |
| n | 1258 | 0.1% |
| Other values (6) | 2787 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1037679 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 342565 | |
| d | 228455 | |
| i | 115428 | 11.1% |
| l | 113760 | 11.0% |
| v | 113578 | 10.9% |
| r | 113570 | 10.9% |
| p | 2639 | 0.3% |
| s | 1852 | 0.2% |
| c | 1787 | 0.2% |
| n | 1258 | 0.1% |
| Other values (6) | 2787 | 0.3% |
| Distinct | 95989 |
|---|---|
| Distinct (%) | 83.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Minimum | 2016-09-04 21:15:19 |
|---|---|
| Maximum | 2018-09-03 09:06:57 |
| Distinct | 88332 |
|---|---|
| Distinct (%) | 76.4% |
| Missing | 14 |
| Missing (%) | < 0.1% |
| Memory size | 1.8 MiB |
| Minimum | 2016-10-04 09:43:32 |
|---|---|
| Maximum | 2018-09-03 17:40:06 |
order_delivered_carrier_date
Date
MISSING 
| Distinct | 79241 |
|---|---|
| Distinct (%) | 69.3% |
| Missing | 1195 |
| Missing (%) | 1.0% |
| Memory size | 1.8 MiB |
| Minimum | 2016-10-08 10:34:01 |
|---|---|
| Maximum | 2018-09-11 19:48:28 |
order_delivered_customer_date
Date
MISSING 
| Distinct | 93702 |
|---|---|
| Distinct (%) | 82.8% |
| Missing | 2400 |
| Missing (%) | 2.1% |
| Memory size | 1.8 MiB |
| Minimum | 2016-10-11 13:46:32 |
|---|---|
| Maximum | 2018-10-17 13:22:46 |
| Distinct | 449 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Minimum | 2016-10-20 00:00:00 |
|---|---|
| Maximum | 2018-10-25 00:00:00 |
| Distinct | 93396 |
|---|---|
| Distinct (%) | 80.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3699488 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 79377 ? |
|---|---|
| Unique (%) | 68.7% |
Sample
| 1st row | 7c396fd4830fd04220f754e42b4e5bff |
|---|---|
| 2nd row | 7c396fd4830fd04220f754e42b4e5bff |
| 3rd row | 7c396fd4830fd04220f754e42b4e5bff |
| 4th row | 3a51803cc0d012c3b5dc8b7528cb05f7 |
| 5th row | ef0996a1a279c26e7ecbd737be23d235 |
| Value | Count | Frequency (%) |
| 9a736b248f67d166d2fbb006bcb877c3 | 75 | 0.1% |
| 6fbc7cdadbb522125f4b27ae9dee4060 | 38 | < 0.1% |
| f9ae226291893fda10af7965268fb7f6 | 35 | < 0.1% |
| 8af7ac63b2efbcbd88e5b11505e8098a | 29 | < 0.1% |
| 569aa12b73b5f7edeaa6f2a01603e381 | 26 | < 0.1% |
| d97b3cfb22b0d6b25ac9ed4e9c2d481b | 24 | < 0.1% |
| 5419a7c9b86a43d8140e2939cd2c2f7e | 24 | < 0.1% |
| db1af3fd6b23ac3873ef02619d548f9c | 24 | < 0.1% |
| 90807fdb59eec2152bc977feeb6e47e7 | 24 | < 0.1% |
| 85963fd37bfd387aa6d915d8a1065486 | 24 | < 0.1% |
| Other values (93386) | 115286 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 232253 | 6.3% |
| b | 231885 | 6.3% |
| 1 | 231813 | 6.3% |
| a | 231488 | 6.3% |
| d | 231353 | 6.3% |
| 3 | 231341 | 6.3% |
| e | 231271 | 6.3% |
| 8 | 231179 | 6.2% |
| 2 | 231112 | 6.2% |
| 5 | 231087 | 6.2% |
| Other values (6) | 1384706 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2312012 | |
| Lowercase Letter | 1387476 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 232253 | |
| 1 | 231813 | |
| 3 | 231341 | |
| 8 | 231179 | |
| 2 | 231112 | |
| 5 | 231087 | |
| 9 | 231084 | |
| 7 | 231012 | |
| 0 | 230821 | |
| 4 | 230310 |
Lowercase Letter
| Value | Count | Frequency (%) |
| b | 231885 | |
| a | 231488 | |
| d | 231353 | |
| e | 231271 | |
| f | 230923 | |
| c | 230556 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2312012 | |
| Latin | 1387476 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 232253 | |
| 1 | 231813 | |
| 3 | 231341 | |
| 8 | 231179 | |
| 2 | 231112 | |
| 5 | 231087 | |
| 9 | 231084 | |
| 7 | 231012 | |
| 0 | 230821 | |
| 4 | 230310 |
Latin
| Value | Count | Frequency (%) |
| b | 231885 | |
| a | 231488 | |
| d | 231353 | |
| e | 231271 | |
| f | 230923 | |
| c | 230556 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3699488 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6 | 232253 | 6.3% |
| b | 231885 | 6.3% |
| 1 | 231813 | 6.3% |
| a | 231488 | 6.3% |
| d | 231353 | 6.3% |
| 3 | 231341 | 6.3% |
| e | 231271 | 6.3% |
| 8 | 231179 | 6.2% |
| 2 | 231112 | 6.2% |
| 5 | 231087 | 6.2% |
| Other values (6) | 1384706 |
customer_zip_code_prefix
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 14907 |
|---|---|
| Distinct (%) | 12.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35061.538 |
| Minimum | 1003 |
|---|---|
| Maximum | 99980 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1003 |
|---|---|
| 5-th percentile | 3286 |
| Q1 | 11310 |
| median | 24241 |
| Q3 | 58745 |
| 95-th percentile | 90620 |
| Maximum | 99980 |
| Range | 98977 |
| Interquartile range (IQR) | 47435 |
Descriptive statistics
| Standard deviation | 29841.672 |
|---|---|
| Coefficient of variation (CV) | 0.85112273 |
| Kurtosis | -0.78410177 |
| Mean | 35061.538 |
| Median Absolute Deviation (MAD) | 16231 |
| Skewness | 0.78436422 |
| Sum | 4.0534293 × 109 |
| Variance | 8.9052537 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24220 | 154 | 0.1% |
| 22793 | 151 | 0.1% |
| 22790 | 150 | 0.1% |
| 24230 | 138 | 0.1% |
| 22775 | 126 | 0.1% |
| 35162 | 124 | 0.1% |
| 29101 | 112 | 0.1% |
| 11740 | 110 | 0.1% |
| 13087 | 107 | 0.1% |
| 36570 | 104 | 0.1% |
| Other values (14897) | 114333 |
| Value | Count | Frequency (%) |
| 1003 | 1 | < 0.1% |
| 1004 | 2 | < 0.1% |
| 1005 | 6 | |
| 1006 | 2 | < 0.1% |
| 1007 | 4 | |
| 1008 | 3 | < 0.1% |
| 1009 | 8 | |
| 1011 | 6 | |
| 1012 | 2 | < 0.1% |
| 1013 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99980 | 3 | < 0.1% |
| 99970 | 1 | < 0.1% |
| 99965 | 2 | < 0.1% |
| 99960 | 1 | < 0.1% |
| 99955 | 3 | < 0.1% |
| 99950 | 9 | |
| 99940 | 2 | < 0.1% |
| 99930 | 5 | |
| 99925 | 1 | < 0.1% |
| 99920 | 1 | < 0.1% |
customer_city
Text
| Distinct | 4093 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 27 |
| Mean length | 10.332855 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1194571 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1042 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | Sao Paulo |
|---|---|
| 2nd row | Sao Paulo |
| 3rd row | Sao Paulo |
| 4th row | Sao Paulo |
| 5th row | Sao Paulo |
| Value | Count | Frequency (%) |
| sao | 24620 | 12.1% |
| paulo | 18348 | 9.1% |
| de | 11267 | 5.6% |
| rio | 9627 | 4.8% |
| janeiro | 8022 | 4.0% |
| do | 4964 | 2.4% |
| belo | 3269 | 1.6% |
| horizonte | 3224 | 1.6% |
| brasilia | 2444 | 1.2% |
| porto | 1942 | 1.0% |
| Other values (3268) | 114916 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 188530 | |
| o | 145141 | |
| 87034 | 7.3% | |
| i | 85625 | 7.2% |
| e | 76426 | 6.4% |
| r | 75382 | 6.3% |
| u | 51224 | 4.3% |
| n | 49130 | 4.1% |
| l | 48521 | 4.1% |
| s | 37481 | 3.1% |
| Other values (46) | 350077 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 903815 | |
| Uppercase Letter | 203181 | 17.0% |
| Space Separator | 87034 | 7.3% |
| Dash Punctuation | 281 | < 0.1% |
| Other Punctuation | 258 | < 0.1% |
| Decimal Number | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 188530 | |
| o | 145141 | |
| i | 85625 | |
| e | 76426 | |
| r | 75382 | 8.3% |
| u | 51224 | 5.7% |
| n | 49130 | 5.4% |
| l | 48521 | 5.4% |
| s | 37481 | 4.1% |
| t | 35486 | 3.9% |
| Other values (16) | 110869 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 35724 | |
| P | 30362 | |
| D | 22298 | |
| C | 17611 | |
| J | 14274 | 7.0% |
| R | 13148 | 6.5% |
| B | 12820 | 6.3% |
| A | 8508 | 4.2% |
| M | 7204 | 3.5% |
| G | 7169 | 3.5% |
| Other values (15) | 34063 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 4 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 87034 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 281 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 258 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1106996 | |
| Common | 87575 | 7.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 188530 | |
| o | 145141 | |
| i | 85625 | 7.7% |
| e | 76426 | 6.9% |
| r | 75382 | 6.8% |
| u | 51224 | 4.6% |
| n | 49130 | 4.4% |
| l | 48521 | 4.4% |
| s | 37481 | 3.4% |
| S | 35724 | 3.2% |
| Other values (41) | 313812 |
Common
| Value | Count | Frequency (%) |
| 87034 | ||
| - | 281 | 0.3% |
| ' | 258 | 0.3% |
| 1 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1194571 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 188530 | |
| o | 145141 | |
| 87034 | 7.3% | |
| i | 85625 | 7.2% |
| e | 76426 | 6.4% |
| r | 75382 | 6.3% |
| u | 51224 | 4.3% |
| n | 49130 | 4.1% |
| l | 48521 | 4.1% |
| s | 37481 | 3.1% |
| Other values (46) | 350077 |
customer_state
Categorical
HIGH CORRELATION 
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| SP | |
|---|---|
| RJ | |
| MG | |
| RS | |
| PR | |
| Other values (22) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 231218 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 48797 | |
| RJ | 14987 | 13.0% |
| MG | 13429 | 11.6% |
| RS | 6413 | 5.5% |
| PR | 5879 | 5.1% |
| SC | 4218 | 3.6% |
| BA | 3942 | 3.4% |
| DF | 2449 | 2.1% |
| GO | 2359 | 2.0% |
| ES | 2300 | 2.0% |
| Other values (17) | 10836 | 9.4% |
Length
| Value | Count | Frequency (%) |
| sp | 48797 | |
| rj | 14987 | 13.0% |
| mg | 13429 | 11.6% |
| rs | 6413 | 5.5% |
| pr | 5879 | 5.1% |
| sc | 4218 | 3.6% |
| ba | 3942 | 3.4% |
| df | 2449 | 2.1% |
| go | 2359 | 2.0% |
| es | 2300 | 2.0% |
| Other values (17) | 10836 | 9.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 62966 | |
| P | 58871 | |
| R | 28218 | |
| M | 16380 | 7.1% |
| G | 15788 | 6.8% |
| J | 14987 | 6.5% |
| A | 6654 | 2.9% |
| E | 6071 | 2.6% |
| C | 5838 | 2.5% |
| B | 4561 | 2.0% |
| Other values (7) | 10884 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 231218 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 62966 | |
| P | 58871 | |
| R | 28218 | |
| M | 16380 | 7.1% |
| G | 15788 | 6.8% |
| J | 14987 | 6.5% |
| A | 6654 | 2.9% |
| E | 6071 | 2.6% |
| C | 5838 | 2.5% |
| B | 4561 | 2.0% |
| Other values (7) | 10884 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 231218 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 62966 | |
| P | 58871 | |
| R | 28218 | |
| M | 16380 | 7.1% |
| G | 15788 | 6.8% |
| J | 14987 | 6.5% |
| A | 6654 | 2.9% |
| E | 6071 | 2.6% |
| C | 5838 | 2.5% |
| B | 4561 | 2.0% |
| Other values (7) | 10884 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 231218 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 62966 | |
| P | 58871 | |
| R | 28218 | |
| M | 16380 | 7.1% |
| G | 15788 | 6.8% |
| J | 14987 | 6.5% |
| A | 6654 | 2.9% |
| E | 6071 | 2.6% |
| C | 5838 | 2.5% |
| B | 4561 | 2.0% |
| Other values (7) | 10884 | 4.7% |
order_item_id
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.194535 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.68592588 |
|---|---|
| Coefficient of variation (CV) | 0.57421998 |
| Kurtosis | 93.440808 |
| Mean | 1.194535 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.195206 |
| Sum | 138099 |
| Variance | 0.47049432 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 101340 | |
| 2 | 10055 | 8.7% |
| 3 | 2326 | 2.0% |
| 4 | 969 | 0.8% |
| 5 | 458 | 0.4% |
| 6 | 256 | 0.2% |
| 7 | 60 | 0.1% |
| 8 | 35 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Other values (11) | 57 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 101340 | |
| 2 | 10055 | 8.7% |
| 3 | 2326 | 2.0% |
| 4 | 969 | 0.8% |
| 5 | 458 | 0.4% |
| 6 | 256 | 0.2% |
| 7 | 60 | 0.1% |
| 8 | 35 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 2 | < 0.1% |
| 17 | 2 | < 0.1% |
| 16 | 2 | < 0.1% |
| 15 | 4 | < 0.1% |
| 14 | 6 | |
| 13 | 7 | |
| 12 | 12 |
product_id
Text
| Distinct | 32171 |
|---|---|
| Distinct (%) | 27.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3699488 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 16932 ? |
|---|---|
| Unique (%) | 14.6% |
Sample
| 1st row | 87285b34884572647811a353c7ac498a |
|---|---|
| 2nd row | 87285b34884572647811a353c7ac498a |
| 3rd row | 87285b34884572647811a353c7ac498a |
| 4th row | 87285b34884572647811a353c7ac498a |
| 5th row | 87285b34884572647811a353c7ac498a |
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 533 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 517 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 507 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 405 | 0.4% |
| 368c6c730842d78016ad823897a372db | 395 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 389 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 354 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 324 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 294 | 0.3% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 276 | 0.2% |
| Other values (32161) | 111615 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 237911 | 6.4% |
| 9 | 235951 | 6.4% |
| e | 233656 | 6.3% |
| 7 | 233105 | 6.3% |
| 8 | 232719 | 6.3% |
| 4 | 231409 | 6.3% |
| a | 231308 | 6.3% |
| c | 231075 | 6.2% |
| 2 | 230954 | 6.2% |
| 6 | 230872 | 6.2% |
| Other values (6) | 1370528 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2321899 | |
| Lowercase Letter | 1377589 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 237911 | |
| 9 | 235951 | |
| 7 | 233105 | |
| 8 | 232719 | |
| 4 | 231409 | |
| 2 | 230954 | |
| 6 | 230872 | |
| 0 | 230822 | |
| 5 | 229692 | |
| 1 | 228464 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 233656 | |
| a | 231308 | |
| c | 231075 | |
| b | 229587 | |
| d | 227350 | |
| f | 224613 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2321899 | |
| Latin | 1377589 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 237911 | |
| 9 | 235951 | |
| 7 | 233105 | |
| 8 | 232719 | |
| 4 | 231409 | |
| 2 | 230954 | |
| 6 | 230872 | |
| 0 | 230822 | |
| 5 | 229692 | |
| 1 | 228464 |
Latin
| Value | Count | Frequency (%) |
| e | 233656 | |
| a | 231308 | |
| c | 231075 | |
| b | 229587 | |
| d | 227350 | |
| f | 224613 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3699488 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 237911 | 6.4% |
| 9 | 235951 | 6.4% |
| e | 233656 | 6.3% |
| 7 | 233105 | 6.3% |
| 8 | 232719 | 6.3% |
| 4 | 231409 | 6.3% |
| a | 231308 | 6.3% |
| c | 231075 | 6.2% |
| 2 | 230954 | 6.2% |
| 6 | 230872 | 6.2% |
| Other values (6) | 1370528 |
seller_id
Text
| Distinct | 3028 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3699488 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 485 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
|---|---|
| 2nd row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 3rd row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 4th row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 5th row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| Value | Count | Frequency (%) |
| 4a3ca9315b744ce9f8e9374361493884 | 2128 | 1.8% |
| 6560211a19b47992c3666cc44a7e94c0 | 2111 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 2009 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1885 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1656 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1517 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1465 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1454 | 1.3% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1236 | 1.1% |
| ea8482cd71df3c1969d7b9473ff13abc | 1233 | 1.1% |
| Other values (3018) | 98915 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 251950 | 6.8% |
| c | 243876 | 6.6% |
| 4 | 243091 | 6.6% |
| 6 | 238193 | 6.4% |
| 0 | 237394 | 6.4% |
| a | 236721 | 6.4% |
| b | 235816 | 6.4% |
| 3 | 235558 | 6.4% |
| 9 | 228810 | 6.2% |
| 2 | 227464 | 6.1% |
| Other values (6) | 1320615 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2339688 | |
| Lowercase Letter | 1359800 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 251950 | |
| 4 | 243091 | |
| 6 | 238193 | |
| 0 | 237394 | |
| 3 | 235558 | |
| 9 | 228810 | |
| 2 | 227464 | |
| 8 | 226366 | |
| 5 | 225942 | |
| 7 | 224920 |
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 243876 | |
| a | 236721 | |
| b | 235816 | |
| e | 216428 | |
| f | 214706 | |
| d | 212253 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2339688 | |
| Latin | 1359800 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 251950 | |
| 4 | 243091 | |
| 6 | 238193 | |
| 0 | 237394 | |
| 3 | 235558 | |
| 9 | 228810 | |
| 2 | 227464 | |
| 8 | 226366 | |
| 5 | 225942 | |
| 7 | 224920 |
Latin
| Value | Count | Frequency (%) |
| c | 243876 | |
| a | 236721 | |
| b | 235816 | |
| e | 216428 | |
| f | 214706 | |
| d | 212253 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3699488 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 251950 | 6.8% |
| c | 243876 | 6.6% |
| 4 | 243091 | 6.6% |
| 6 | 238193 | 6.4% |
| 0 | 237394 | 6.4% |
| a | 236721 | 6.4% |
| b | 235816 | 6.4% |
| 3 | 235558 | 6.4% |
| 9 | 228810 | 6.2% |
| 2 | 227464 | 6.1% |
| Other values (6) | 1320615 |
| Distinct | 91386 |
|---|---|
| Distinct (%) | 79.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Minimum | 2016-09-19 00:15:34 |
|---|---|
| Maximum | 2020-04-09 22:35:08 |
price
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 5879 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.61985 |
| Minimum | 0.85 |
|---|---|
| Maximum | 6735 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0.85 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 39.9 |
| median | 74.9 |
| Q3 | 134.9 |
| 95-th percentile | 349.9 |
| Maximum | 6735 |
| Range | 6734.15 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 182.65348 |
|---|---|
| Coefficient of variation (CV) | 1.5142904 |
| Kurtosis | 107.9051 |
| Mean | 120.61985 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 7.6154182 |
| Sum | 13944740 |
| Variance | 33362.292 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.9 | 2574 | 2.2% |
| 69.9 | 2096 | 1.8% |
| 49.9 | 2013 | 1.7% |
| 89.9 | 1604 | 1.4% |
| 99.9 | 1505 | 1.3% |
| 29.9 | 1362 | 1.2% |
| 39.9 | 1325 | 1.1% |
| 79.9 | 1266 | 1.1% |
| 19.9 | 1263 | 1.1% |
| 29.99 | 1204 | 1.0% |
| Other values (5869) | 99397 |
| Value | Count | Frequency (%) |
| 0.85 | 3 | < 0.1% |
| 1.2 | 20 | |
| 2.2 | 2 | < 0.1% |
| 2.29 | 1 | < 0.1% |
| 2.9 | 1 | < 0.1% |
| 2.99 | 1 | < 0.1% |
| 3.06 | 3 | < 0.1% |
| 3.49 | 3 | < 0.1% |
| 3.5 | 7 | < 0.1% |
| 3.54 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6735 | 1 | |
| 6499 | 1 | |
| 4799 | 1 | |
| 4690 | 1 | |
| 4590 | 1 | |
| 4399.87 | 1 | |
| 4099.99 | 1 | |
| 4059 | 1 | |
| 3999.9 | 1 | |
| 3999 | 2 |
freight_value
Real number (ℝ)
| Distinct | 6954 |
|---|---|
| Distinct (%) | 6.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.05688 |
| Minimum | 0 |
|---|---|
| Maximum | 409.68 |
| Zeros | 387 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.78 |
| Q1 | 13.08 |
| median | 16.32 |
| Q3 | 21.21 |
| 95-th percentile | 45.31 |
| Maximum | 409.68 |
| Range | 409.68 |
| Interquartile range (IQR) | 8.13 |
Descriptive statistics
| Standard deviation | 15.836184 |
|---|---|
| Coefficient of variation (CV) | 0.78956371 |
| Kurtosis | 58.250048 |
| Mean | 20.05688 |
| Median Absolute Deviation (MAD) | 3.63 |
| Skewness | 5.5602128 |
| Sum | 2318755.8 |
| Variance | 250.78473 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.1 | 3754 | 3.2% |
| 7.78 | 2281 | 2.0% |
| 11.85 | 1948 | 1.7% |
| 14.1 | 1939 | 1.7% |
| 18.23 | 1599 | 1.4% |
| 7.39 | 1554 | 1.3% |
| 16.11 | 1185 | 1.0% |
| 15.23 | 1041 | 0.9% |
| 8.72 | 950 | 0.8% |
| 16.79 | 902 | 0.8% |
| Other values (6944) | 98456 |
| Value | Count | Frequency (%) |
| 0 | 387 | |
| 0.01 | 4 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 14 | < 0.1% |
| 0.04 | 4 | < 0.1% |
| 0.05 | 3 | < 0.1% |
| 0.06 | 13 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 12 | < 0.1% |
| 0.09 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 409.68 | 1 | |
| 375.28 | 2 | |
| 339.59 | 1 | |
| 338.3 | 1 | |
| 322.1 | 1 | |
| 321.88 | 1 | |
| 321.46 | 1 | |
| 317.47 | 1 | |
| 314.4 | 1 | |
| 314.02 | 1 |
payment_sequential
Real number (ℝ)
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.093747 |
| Minimum | 1 |
|---|---|
| Maximum | 29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 29 |
| Range | 28 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.72984871 |
|---|---|
| Coefficient of variation (CV) | 0.66729206 |
| Kurtosis | 350.44021 |
| Mean | 1.093747 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.001768 |
| Sum | 126447 |
| Variance | 0.53267914 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 110662 | |
| 2 | 3298 | 2.9% |
| 3 | 636 | 0.6% |
| 4 | 307 | 0.3% |
| 5 | 183 | 0.2% |
| 6 | 127 | 0.1% |
| 7 | 88 | 0.1% |
| 8 | 58 | 0.1% |
| 9 | 47 | < 0.1% |
| 10 | 40 | < 0.1% |
| Other values (19) | 163 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 110662 | |
| 2 | 3298 | 2.9% |
| 3 | 636 | 0.6% |
| 4 | 307 | 0.3% |
| 5 | 183 | 0.2% |
| 6 | 127 | 0.1% |
| 7 | 88 | 0.1% |
| 8 | 58 | 0.1% |
| 9 | 47 | < 0.1% |
| 10 | 40 | < 0.1% |
| Value | Count | Frequency (%) |
| 29 | 1 | < 0.1% |
| 28 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 25 | 2 | < 0.1% |
| 24 | 2 | < 0.1% |
| 23 | 2 | < 0.1% |
| 22 | 3 | |
| 21 | 6 | |
| 20 | 6 |
payment_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Credit Card | |
|---|---|
| Boleto | |
| Voucher | 6162 |
| Debit Card | 1659 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.7989084 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1132842 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Credit Card |
|---|---|
| 2nd row | Voucher |
| 3rd row | Voucher |
| 4th row | Credit Card |
| 5th row | Credit Card |
Common Values
| Value | Count | Frequency (%) |
| Credit Card | 85278 | |
| Boleto | 22510 | 19.5% |
| Voucher | 6162 | 5.3% |
| Debit Card | 1659 | 1.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| card | 86937 | |
| credit | 85278 | |
| boleto | 22510 | 11.1% |
| voucher | 6162 | 3.0% |
| debit | 1659 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 178377 | |
| C | 172215 | |
| d | 172215 | |
| e | 115609 | |
| t | 109447 | |
| i | 86937 | |
| 86937 | ||
| a | 86937 | |
| o | 51182 | 4.5% |
| l | 22510 | 2.0% |
| Other values (7) | 50476 | 4.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 843359 | |
| Uppercase Letter | 202546 | 17.9% |
| Space Separator | 86937 | 7.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 178377 | |
| d | 172215 | |
| e | 115609 | |
| t | 109447 | |
| i | 86937 | |
| a | 86937 | |
| o | 51182 | 6.1% |
| l | 22510 | 2.7% |
| u | 6162 | 0.7% |
| c | 6162 | 0.7% |
| Other values (2) | 7821 | 0.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 172215 | |
| B | 22510 | 11.1% |
| V | 6162 | 3.0% |
| D | 1659 | 0.8% |
Space Separator
| Value | Count | Frequency (%) |
| 86937 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1045905 | |
| Common | 86937 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 178377 | |
| C | 172215 | |
| d | 172215 | |
| e | 115609 | |
| t | 109447 | |
| i | 86937 | |
| a | 86937 | |
| o | 51182 | 4.9% |
| l | 22510 | 2.2% |
| B | 22510 | 2.2% |
| Other values (6) | 27966 | 2.7% |
Common
| Value | Count | Frequency (%) |
| 86937 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1132842 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 178377 | |
| C | 172215 | |
| d | 172215 | |
| e | 115609 | |
| t | 109447 | |
| i | 86937 | |
| 86937 | ||
| a | 86937 | |
| o | 51182 | 4.5% |
| l | 22510 | 2.0% |
| Other values (7) | 50476 | 4.5% |
payment_installments
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9462326 |
| Minimum | 0 |
|---|---|
| Maximum | 24 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 10 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.7810871 |
|---|---|
| Coefficient of variation (CV) | 0.94394691 |
| Kurtosis | 2.5137681 |
| Mean | 2.9462326 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.6181717 |
| Sum | 340611 |
| Variance | 7.7344456 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 57599 | |
| 2 | 13404 | 11.6% |
| 3 | 11551 | 10.0% |
| 4 | 7855 | 6.8% |
| 10 | 6785 | 5.9% |
| 5 | 5928 | 5.1% |
| 8 | 5013 | 4.3% |
| 6 | 4546 | 3.9% |
| 7 | 1789 | 1.5% |
| 9 | 710 | 0.6% |
| Other values (14) | 429 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 3 | < 0.1% |
| 1 | 57599 | |
| 2 | 13404 | 11.6% |
| 3 | 11551 | 10.0% |
| 4 | 7855 | 6.8% |
| 5 | 5928 | 5.1% |
| 6 | 4546 | 3.9% |
| 7 | 1789 | 1.5% |
| 8 | 5013 | 4.3% |
| 9 | 710 | 0.6% |
| Value | Count | Frequency (%) |
| 24 | 34 | < 0.1% |
| 23 | 1 | < 0.1% |
| 22 | 1 | < 0.1% |
| 21 | 6 | < 0.1% |
| 20 | 20 | < 0.1% |
| 18 | 38 | |
| 17 | 7 | < 0.1% |
| 16 | 7 | < 0.1% |
| 15 | 91 | |
| 14 | 16 | < 0.1% |
payment_value
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 28657 |
|---|---|
| Distinct (%) | 24.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 172.38738 |
| Minimum | 0 |
|---|---|
| Maximum | 13664.08 |
| Zeros | 6 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27.23 |
| Q1 | 60.87 |
| median | 108.05 |
| Q3 | 189.48 |
| 95-th percentile | 514.98 |
| Maximum | 13664.08 |
| Range | 13664.08 |
| Interquartile range (IQR) | 128.61 |
Descriptive statistics
| Standard deviation | 265.87397 |
|---|---|
| Coefficient of variation (CV) | 1.5423053 |
| Kurtosis | 524.94523 |
| Mean | 172.38738 |
| Median Absolute Deviation (MAD) | 56.67 |
| Skewness | 14.306544 |
| Sum | 19929532 |
| Variance | 70688.967 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 338 | 0.3% |
| 100 | 285 | 0.2% |
| 20 | 283 | 0.2% |
| 77.57 | 249 | 0.2% |
| 35 | 163 | 0.1% |
| 73.34 | 157 | 0.1% |
| 30 | 134 | 0.1% |
| 116.94 | 130 | 0.1% |
| 56.78 | 120 | 0.1% |
| 155.14 | 119 | 0.1% |
| Other values (28647) | 113631 |
| Value | Count | Frequency (%) |
| 0 | 6 | |
| 0.01 | 6 | |
| 0.03 | 2 | < 0.1% |
| 0.05 | 2 | < 0.1% |
| 0.08 | 2 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 3 | |
| 0.11 | 2 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.14 | 4 |
| Value | Count | Frequency (%) |
| 13664.08 | 8 | |
| 7274.88 | 4 | |
| 6929.31 | 1 | < 0.1% |
| 6726.66 | 1 | < 0.1% |
| 6081.54 | 6 | |
| 4950.34 | 1 | < 0.1% |
| 4809.44 | 2 | < 0.1% |
| 4764.34 | 1 | < 0.1% |
| 4681.78 | 1 | < 0.1% |
| 4513.32 | 1 | < 0.1% |
review_id
Text
| Distinct | 96319 |
|---|---|
| Distinct (%) | 83.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 3699488 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 83596 ? |
|---|---|
| Unique (%) | 72.3% |
Sample
| 1st row | a54f0611adc9ed256b57ede6b6eb5114 |
|---|---|
| 2nd row | a54f0611adc9ed256b57ede6b6eb5114 |
| 3rd row | a54f0611adc9ed256b57ede6b6eb5114 |
| 4th row | b46f1e34512b0f4c74a72398b03ca788 |
| 5th row | dc90f19c2806f1abba9e72ad3c350073 |
| Value | Count | Frequency (%) |
| eef5dbca8d37dfce6db7d7b16dd0525e | 63 | 0.1% |
| 7145a6f0d38ec713897856cbdcfcdb7f | 38 | < 0.1% |
| f28281373ab8815bafafe371218f02ce | 29 | < 0.1% |
| 8823bba1e3301fee652eb06de8ef9435 | 26 | < 0.1% |
| b79b22bb50f78f1afe361661011fd892 | 24 | < 0.1% |
| b5292206f96cd5d97359940203a0b510 | 24 | < 0.1% |
| b0c2f8c122ebef9f77753f7d167cf634 | 24 | < 0.1% |
| cc074f1c33940c4f0dd904705f98e39e | 24 | < 0.1% |
| 7e568736c98c553aea896a5dca746d5a | 22 | < 0.1% |
| 6fe49ee0a2b00dddf7ebddb5847f9283 | 21 | < 0.1% |
| Other values (96309) | 115314 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 232033 | 6.3% |
| 6 | 232011 | 6.3% |
| 8 | 231576 | 6.3% |
| 5 | 231572 | 6.3% |
| d | 231486 | 6.3% |
| f | 231421 | 6.3% |
| b | 231386 | 6.3% |
| 1 | 231303 | 6.3% |
| 0 | 231222 | 6.3% |
| 2 | 231089 | 6.2% |
| Other values (6) | 1384389 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2311211 | |
| Lowercase Letter | 1388277 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 232011 | |
| 8 | 231576 | |
| 5 | 231572 | |
| 1 | 231303 | |
| 0 | 231222 | |
| 2 | 231089 | |
| 7 | 230957 | |
| 9 | 230772 | |
| 3 | 230468 | |
| 4 | 230241 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 232033 | |
| d | 231486 | |
| f | 231421 | |
| b | 231386 | |
| e | 231008 | |
| c | 230943 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2311211 | |
| Latin | 1388277 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 232011 | |
| 8 | 231576 | |
| 5 | 231572 | |
| 1 | 231303 | |
| 0 | 231222 | |
| 2 | 231089 | |
| 7 | 230957 | |
| 9 | 230772 | |
| 3 | 230468 | |
| 4 | 230241 |
Latin
| Value | Count | Frequency (%) |
| a | 232033 | |
| d | 231486 | |
| f | 231421 | |
| b | 231386 | |
| e | 231008 | |
| c | 230943 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3699488 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 232033 | 6.3% |
| 6 | 232011 | 6.3% |
| 8 | 231576 | 6.3% |
| 5 | 231572 | 6.3% |
| d | 231486 | 6.3% |
| f | 231421 | 6.3% |
| b | 231386 | 6.3% |
| 1 | 231303 | 6.3% |
| 0 | 231222 | 6.3% |
| 2 | 231089 | 6.2% |
| Other values (6) | 1384389 |
review_score
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| 5 | |
|---|---|
| 4 | |
| 1 | |
| 3 | |
| 2 | 4020 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 115609 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 4 |
| 3rd row | 4 |
| 4th row | 4 |
| 5th row | 5 |
Common Values
| Value | Count | Frequency (%) |
| 5 | 65374 | |
| 4 | 21951 | 19.0% |
| 1 | 14546 | 12.6% |
| 3 | 9718 | 8.4% |
| 2 | 4020 | 3.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 5 | 65374 | |
| 4 | 21951 | 19.0% |
| 1 | 14546 | 12.6% |
| 3 | 9718 | 8.4% |
| 2 | 4020 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 65374 | |
| 4 | 21951 | 19.0% |
| 1 | 14546 | 12.6% |
| 3 | 9718 | 8.4% |
| 2 | 4020 | 3.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 115609 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 65374 | |
| 4 | 21951 | 19.0% |
| 1 | 14546 | 12.6% |
| 3 | 9718 | 8.4% |
| 2 | 4020 | 3.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 115609 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 5 | 65374 | |
| 4 | 21951 | 19.0% |
| 1 | 14546 | 12.6% |
| 3 | 9718 | 8.4% |
| 2 | 4020 | 3.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 115609 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5 | 65374 | |
| 4 | 21951 | 19.0% |
| 1 | 14546 | 12.6% |
| 3 | 9718 | 8.4% |
| 2 | 4020 | 3.5% |
MISSING 
| Distinct | 4477 |
|---|---|
| Distinct (%) | 32.4% |
| Missing | 101808 |
| Missing (%) | 88.1% |
| Memory size | 1.8 MiB |
Length
| Max length | 26 |
|---|---|
| Median length | 20 |
| Mean length | 12.187523 |
| Min length | 1 |
Characters and Unicode
| Total characters | 168200 |
|---|---|
| Distinct characters | 125 |
| Distinct categories | 14 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 3063 ? |
|---|---|
| Unique (%) | 22.2% |
Sample
| 1st row | Pedido recebido corretame |
|---|---|
| 2nd row | Ótimo |
| 3rd row | ok, muito profissional |
| 4th row | Ótimo |
| 5th row | Tenho uma reclamação |
| Value | Count | Frequency (%) |
| recomendo | 2442 | 9.3% |
| produto | 1541 | 5.8% |
| bom | 1512 | 5.7% |
| muito | 1036 | 3.9% |
| super | 1033 | 3.9% |
| não | 904 | 3.4% |
| ótimo | 799 | 3.0% |
| excelente | 763 | 2.9% |
| entrega | 698 | 2.6% |
| recebi | 435 | 1.7% |
| Other values (2076) | 15191 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 20935 | 12.4% |
| e | 17995 | 10.7% |
| 14939 | 8.9% | |
| r | 9698 | 5.8% |
| t | 9295 | 5.5% |
| a | 8991 | 5.3% |
| m | 8319 | 4.9% |
| d | 8093 | 4.8% |
| i | 7977 | 4.7% |
| n | 7525 | 4.5% |
| Other values (115) | 54433 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 130612 | |
| Uppercase Letter | 18662 | 11.1% |
| Space Separator | 14939 | 8.9% |
| Other Punctuation | 2659 | 1.6% |
| Decimal Number | 1226 | 0.7% |
| Other Symbol | 48 | < 0.1% |
| Dash Punctuation | 19 | < 0.1% |
| Modifier Symbol | 13 | < 0.1% |
| Math Symbol | 8 | < 0.1% |
| Close Punctuation | 7 | < 0.1% |
| Other values (4) | 7 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 20935 | |
| e | 17995 | |
| r | 9698 | 7.4% |
| t | 9295 | 7.1% |
| a | 8991 | 6.9% |
| m | 8319 | 6.4% |
| d | 8093 | 6.2% |
| i | 7977 | 6.1% |
| n | 7525 | 5.8% |
| c | 5854 | 4.5% |
| Other values (31) | 25930 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 2511 | |
| R | 2031 | |
| O | 1666 | 8.9% |
| P | 1580 | 8.5% |
| M | 1441 | 7.7% |
| N | 1172 | 6.3% |
| S | 1035 | 5.5% |
| A | 974 | 5.2% |
| Ó | 924 | 5.0% |
| B | 890 | 4.8% |
| Other values (26) | 4438 |
Other Punctuation
| Value | Count | Frequency (%) |
| ! | 1200 | |
| . | 782 | |
| * | 399 | 15.0% |
| , | 152 | 5.7% |
| ? | 50 | 1.9% |
| / | 36 | 1.4% |
| % | 21 | 0.8% |
| : | 6 | 0.2% |
| ; | 4 | 0.2% |
| " | 3 | 0.1% |
| Other values (4) | 6 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 461 | |
| 1 | 410 | |
| 5 | 80 | 6.5% |
| 2 | 75 | 6.1% |
| 8 | 46 | 3.8% |
| 3 | 42 | 3.4% |
| 4 | 39 | 3.2% |
| 9 | 29 | 2.4% |
| 7 | 23 | 1.9% |
| 6 | 21 | 1.7% |
Other Symbol
| Value | Count | Frequency (%) |
| 👍 | 16 | |
| 😍 | 9 | |
| 👏 | 7 | |
| 🌟 | 6 | 12.5% |
| 💥 | 5 | 10.4% |
| 👎 | 1 | 2.1% |
| 🤗 | 1 | 2.1% |
| 🚚 | 1 | 2.1% |
| 😀 | 1 | 2.1% |
| 🔟 | 1 | 2.1% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ´ | 6 | |
| 🏻 | 3 | |
| 🏼 | 2 | 15.4% |
| 🏽 | 2 | 15.4% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 7 | |
| = | 1 | 12.5% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 6 | |
| ] | 1 | 14.3% |
Space Separator
| Value | Count | Frequency (%) |
| 14939 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 19 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 4 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Other Letter
| Value | Count | Frequency (%) |
| ª | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 149275 | |
| Common | 18925 | 11.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 20935 | |
| e | 17995 | |
| r | 9698 | 6.5% |
| t | 9295 | 6.2% |
| a | 8991 | 6.0% |
| m | 8319 | 5.6% |
| d | 8093 | 5.4% |
| i | 7977 | 5.3% |
| n | 7525 | 5.0% |
| c | 5854 | 3.9% |
| Other values (68) | 44593 |
Common
| Value | Count | Frequency (%) |
| 14939 | ||
| ! | 1200 | 6.3% |
| . | 782 | 4.1% |
| 0 | 461 | 2.4% |
| 1 | 410 | 2.2% |
| * | 399 | 2.1% |
| , | 152 | 0.8% |
| 5 | 80 | 0.4% |
| 2 | 75 | 0.4% |
| ? | 50 | 0.3% |
| Other values (37) | 377 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 164629 | |
| None | 3561 | 2.1% |
| Emoticons | 10 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 20935 | |
| e | 17995 | 10.9% |
| 14939 | 9.1% | |
| r | 9698 | 5.9% |
| t | 9295 | 5.6% |
| a | 8991 | 5.5% |
| m | 8319 | 5.1% |
| d | 8093 | 4.9% |
| i | 7977 | 4.8% |
| n | 7525 | 4.6% |
| Other values (75) | 50862 |
None
| Value | Count | Frequency (%) |
| ã | 1086 | |
| Ó | 924 | |
| á | 356 | 10.0% |
| ç | 342 | 9.6% |
| é | 249 | 7.0% |
| ó | 245 | 6.9% |
| Ã | 71 | 2.0% |
| í | 64 | 1.8% |
| ê | 45 | 1.3% |
| É | 29 | 0.8% |
| Other values (28) | 150 | 4.2% |
Emoticons
| Value | Count | Frequency (%) |
| 😍 | 9 | |
| 😀 | 1 | 10.0% |
MISSING 
| Distinct | 35176 |
|---|---|
| Distinct (%) | 71.9% |
| Missing | 66703 |
| Missing (%) | 57.7% |
| Memory size | 1.8 MiB |
Length
| Max length | 208 |
|---|---|
| Median length | 158 |
| Mean length | 70.205149 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3433453 |
|---|---|
| Distinct characters | 205 |
| Distinct categories | 15 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 28730 ? |
|---|---|
| Unique (%) | 58.7% |
Sample
| 1st row | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
|---|---|
| 2nd row | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
| 3rd row | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
| 4th row | Deveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente. |
| 5th row | Só achei ela pequena pra seis xícaras ,mais é um bom produto |
| Value | Count | Frequency (%) |
| o | 22075 | 3.8% |
| produto | 20487 | 3.5% |
| e | 19397 | 3.3% |
| a | 14735 | 2.5% |
| de | 14075 | 2.4% |
| do | 12785 | 2.2% |
| não | 12702 | 2.2% |
| que | 10115 | 1.7% |
| prazo | 9242 | 1.6% |
| muito | 8930 | 1.5% |
| Other values (19329) | 441610 |
Most occurring characters
| Value | Count | Frequency (%) |
| 543604 | ||
| o | 338902 | 9.9% |
| e | 329088 | 9.6% |
| a | 272669 | 7.9% |
| r | 193607 | 5.6% |
| i | 158463 | 4.6% |
| t | 156573 | 4.6% |
| d | 145458 | 4.2% |
| n | 133224 | 3.9% |
| s | 129633 | 3.8% |
| Other values (195) | 1032232 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2595479 | |
| Space Separator | 543604 | 15.8% |
| Uppercase Letter | 162409 | 4.7% |
| Other Punctuation | 93611 | 2.7% |
| Decimal Number | 21346 | 0.6% |
| Control | 13578 | 0.4% |
| Dash Punctuation | 943 | < 0.1% |
| Close Punctuation | 718 | < 0.1% |
| Open Punctuation | 701 | < 0.1% |
| Other Symbol | 690 | < 0.1% |
| Other values (5) | 374 | < 0.1% |
Most frequent character per category
Other Symbol
| Value | Count | Frequency (%) |
| 👏 | 241 | |
| 👍 | 86 | 12.5% |
| 😍 | 74 | 10.7% |
| ° | 27 | 3.9% |
| 😉 | 22 | 3.2% |
| 😘 | 20 | 2.9% |
| 😆 | 19 | 2.8% |
| 😡 | 18 | 2.6% |
| 😁 | 13 | 1.9% |
| 👎 | 13 | 1.9% |
| Other values (51) | 157 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 338902 | |
| e | 329088 | |
| a | 272669 | |
| r | 193607 | 7.5% |
| i | 158463 | 6.1% |
| t | 156573 | 6.0% |
| d | 145458 | 5.6% |
| n | 133224 | 5.1% |
| s | 129633 | 5.0% |
| m | 124354 | 4.8% |
| Other values (40) | 613508 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 19186 | |
| O | 18074 | |
| A | 16813 | |
| P | 12154 | 7.5% |
| R | 11806 | 7.3% |
| C | 9540 | 5.9% |
| N | 9239 | 5.7% |
| M | 9162 | 5.6% |
| S | 8085 | 5.0% |
| T | 7584 | 4.7% |
| Other values (31) | 40766 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 49261 | |
| , | 27288 | |
| ! | 12446 | 13.3% |
| / | 1787 | 1.9% |
| ? | 1566 | 1.7% |
| " | 410 | 0.4% |
| : | 301 | 0.3% |
| ; | 222 | 0.2% |
| % | 192 | 0.2% |
| * | 72 | 0.1% |
| Other values (5) | 66 | 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4919 | |
| 1 | 4891 | |
| 2 | 4095 | |
| 3 | 1917 | 9.0% |
| 4 | 1328 | 6.2% |
| 5 | 1223 | 5.7% |
| 8 | 921 | 4.3% |
| 6 | 877 | 4.1% |
| 7 | 717 | 3.4% |
| 9 | 458 | 2.1% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 88 | |
| = | 27 | 18.8% |
| | | 12 | 8.3% |
| < | 9 | 6.2% |
| ~ | 3 | 2.1% |
| × | 2 | 1.4% |
| > | 2 | 1.4% |
| ÷ | 1 | 0.7% |
Modifier Symbol
| Value | Count | Frequency (%) |
| 🏻 | 34 | |
| ´ | 26 | |
| 🏼 | 15 | |
| 🏽 | 13 | 12.7% |
| ^ | 8 | 7.8% |
| 🏾 | 4 | 3.9% |
| ` | 2 | 2.0% |
Control
| Value | Count | Frequency (%) |
| 6779 | ||
| 6779 | ||
| 20 | 0.1% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 715 | |
| ] | 3 | 0.4% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 695 | |
| [ | 6 | 0.9% |
Other Letter
| Value | Count | Frequency (%) |
| º | 24 | |
| ª | 19 |
Space Separator
| Value | Count | Frequency (%) |
| 543604 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 943 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 77 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 8 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2757931 | |
| Common | 675522 | 19.7% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 543604 | ||
| . | 49261 | 7.3% |
| , | 27288 | 4.0% |
| ! | 12446 | 1.8% |
| 6779 | 1.0% | |
| 6779 | 1.0% | |
| 0 | 4919 | 0.7% |
| 1 | 4891 | 0.7% |
| 2 | 4095 | 0.6% |
| 3 | 1917 | 0.3% |
| Other values (102) | 13543 | 2.0% |
Latin
| Value | Count | Frequency (%) |
| o | 338902 | |
| e | 329088 | |
| a | 272669 | 9.9% |
| r | 193607 | 7.0% |
| i | 158463 | 5.7% |
| t | 156573 | 5.7% |
| d | 145458 | 5.3% |
| n | 133224 | 4.8% |
| s | 129633 | 4.7% |
| m | 124354 | 4.5% |
| Other values (83) | 775960 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3371158 | |
| None | 62050 | 1.8% |
| Emoticons | 245 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 543604 | ||
| o | 338902 | 10.1% |
| e | 329088 | 9.8% |
| a | 272669 | 8.1% |
| r | 193607 | 5.7% |
| i | 158463 | 4.7% |
| t | 156573 | 4.6% |
| d | 145458 | 4.3% |
| n | 133224 | 4.0% |
| s | 129633 | 3.8% |
| Other values (85) | 969937 |
None
| Value | Count | Frequency (%) |
| ã | 18253 | |
| é | 11197 | |
| á | 8923 | |
| ç | 7252 | 11.7% |
| ó | 6189 | 10.0% |
| ê | 1902 | 3.1% |
| í | 1714 | 2.8% |
| Ó | 1543 | 2.5% |
| õ | 908 | 1.5% |
| ú | 886 | 1.4% |
| Other values (71) | 3283 | 5.3% |
Emoticons
| Value | Count | Frequency (%) |
| 😍 | 74 | |
| 😉 | 22 | 9.0% |
| 😘 | 20 | 8.2% |
| 😆 | 19 | 7.8% |
| 😡 | 18 | 7.3% |
| 😁 | 13 | 5.3% |
| 😊 | 12 | 4.9% |
| 😀 | 8 | 3.3% |
| 😩 | 7 | 2.9% |
| 😃 | 6 | 2.4% |
| Other values (19) | 46 |
| Distinct | 632 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Minimum | 2016-10-15 00:00:00 |
|---|---|
| Maximum | 2018-08-31 00:00:00 |
| Distinct | 96163 |
|---|---|
| Distinct (%) | 83.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Minimum | 2016-10-16 03:20:17 |
|---|---|
| Maximum | 2018-10-29 12:27:35 |
| Distinct | 71 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 30 |
| Mean length | 14.875062 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1719691 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | utilidades_domesticas |
|---|---|
| 2nd row | utilidades_domesticas |
| 3rd row | utilidades_domesticas |
| 4th row | utilidades_domesticas |
| 5th row | utilidades_domesticas |
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11847 | 10.2% |
| beleza_saude | 9944 | 8.6% |
| esporte_lazer | 8942 | 7.7% |
| moveis_decoracao | 8743 | 7.6% |
| informatica_acessorios | 8105 | 7.0% |
| utilidades_domesticas | 7331 | 6.3% |
| relogios_presentes | 6161 | 5.3% |
| telefonia | 4692 | 4.1% |
| ferramentas_jardim | 4558 | 3.9% |
| automotivo | 4356 | 3.8% |
| Other values (61) | 40930 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 208749 | |
| a | 206939 | |
| s | 171469 | |
| o | 170145 | |
| i | 114273 | 6.6% |
| r | 110581 | 6.4% |
| _ | 109454 | 6.4% |
| t | 82596 | 4.8% |
| c | 81711 | 4.8% |
| m | 77941 | 4.5% |
| Other values (18) | 385833 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1609941 | |
| Connector Punctuation | 109454 | 6.4% |
| Decimal Number | 296 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 208749 | |
| a | 206939 | |
| s | 171469 | |
| o | 170145 | |
| i | 114273 | 7.1% |
| r | 110581 | 6.9% |
| t | 82596 | 5.1% |
| c | 81711 | 5.1% |
| m | 77941 | 4.8% |
| n | 58609 | 3.6% |
| Other values (16) | 326928 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 109454 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 296 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1609941 | |
| Common | 109750 | 6.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 208749 | |
| a | 206939 | |
| s | 171469 | |
| o | 170145 | |
| i | 114273 | 7.1% |
| r | 110581 | 6.9% |
| t | 82596 | 5.1% |
| c | 81711 | 5.1% |
| m | 77941 | 4.8% |
| n | 58609 | 3.6% |
| Other values (16) | 326928 |
Common
| Value | Count | Frequency (%) |
| _ | 109454 | |
| 2 | 296 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1719691 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 208749 | |
| a | 206939 | |
| s | 171469 | |
| o | 170145 | |
| i | 114273 | 6.6% |
| r | 110581 | 6.4% |
| _ | 109454 | 6.4% |
| t | 82596 | 4.8% |
| c | 81711 | 4.8% |
| m | 77941 | 4.5% |
| Other values (18) | 385833 |
product_name_lenght
Real number (ℝ)
| Distinct | 66 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.766541 |
| Minimum | 5 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 42 |
| median | 52 |
| Q3 | 57 |
| 95-th percentile | 60 |
| Maximum | 76 |
| Range | 71 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.034187 |
|---|---|
| Coefficient of variation (CV) | 0.20575966 |
| Kurtosis | 0.14955291 |
| Mean | 48.766541 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.90541969 |
| Sum | 5637851 |
| Variance | 100.68491 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59 | 8598 | 7.4% |
| 60 | 8004 | 6.9% |
| 56 | 6803 | 5.9% |
| 58 | 6753 | 5.8% |
| 57 | 6261 | 5.4% |
| 55 | 5797 | 5.0% |
| 54 | 5469 | 4.7% |
| 53 | 4319 | 3.7% |
| 52 | 4280 | 3.7% |
| 49 | 3670 | 3.2% |
| Other values (56) | 55655 |
| Value | Count | Frequency (%) |
| 5 | 9 | < 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 14 | < 0.1% |
| 10 | 8 | < 0.1% |
| 11 | 11 | < 0.1% |
| 12 | 37 | |
| 13 | 26 | |
| 14 | 47 |
| Value | Count | Frequency (%) |
| 76 | 1 | < 0.1% |
| 72 | 9 | < 0.1% |
| 69 | 1 | < 0.1% |
| 68 | 1 | < 0.1% |
| 67 | 3 | < 0.1% |
| 66 | 1 | < 0.1% |
| 64 | 170 | 0.1% |
| 63 | 1335 | |
| 62 | 160 | 0.1% |
| 61 | 239 | 0.2% |
product_description_lenght
Real number (ℝ)
| Distinct | 2958 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 785.8082 |
| Minimum | 4 |
|---|---|
| Maximum | 3992 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 160 |
| Q1 | 346 |
| median | 600 |
| Q3 | 983 |
| 95-th percentile | 2120 |
| Maximum | 3992 |
| Range | 3988 |
| Interquartile range (IQR) | 637 |
Descriptive statistics
| Standard deviation | 652.41862 |
|---|---|
| Coefficient of variation (CV) | 0.83025173 |
| Kurtosis | 4.9272446 |
| Mean | 785.8082 |
| Median Absolute Deviation (MAD) | 295 |
| Skewness | 2.011533 |
| Sum | 90846500 |
| Variance | 425650.05 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 341 | 708 | 0.6% |
| 1893 | 664 | 0.6% |
| 348 | 643 | 0.6% |
| 492 | 590 | 0.5% |
| 903 | 588 | 0.5% |
| 245 | 576 | 0.5% |
| 366 | 532 | 0.5% |
| 236 | 513 | 0.4% |
| 340 | 484 | 0.4% |
| 919 | 436 | 0.4% |
| Other values (2948) | 109875 |
| Value | Count | Frequency (%) |
| 4 | 6 | |
| 8 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 20 | 7 | |
| 23 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 27 | 4 | |
| 28 | 2 | < 0.1% |
| 30 | 8 | |
| 31 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3992 | 2 | < 0.1% |
| 3988 | 1 | < 0.1% |
| 3985 | 3 | |
| 3976 | 6 | |
| 3963 | 1 | < 0.1% |
| 3956 | 3 | |
| 3954 | 2 | < 0.1% |
| 3950 | 2 | < 0.1% |
| 3949 | 1 | < 0.1% |
| 3948 | 1 | < 0.1% |
product_photos_qty
Real number (ℝ)
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2053733 |
| Minimum | 1 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.717771 |
|---|---|
| Coefficient of variation (CV) | 0.7789026 |
| Kurtosis | 4.8372556 |
| Mean | 2.2053733 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.910868 |
| Sum | 254961 |
| Variance | 2.9507372 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 58429 | |
| 2 | 22894 | 19.8% |
| 3 | 12869 | 11.1% |
| 4 | 8770 | 7.6% |
| 5 | 5558 | 4.8% |
| 6 | 3905 | 3.4% |
| 7 | 1552 | 1.3% |
| 8 | 771 | 0.7% |
| 10 | 353 | 0.3% |
| 9 | 309 | 0.3% |
| Other values (9) | 199 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 58429 | |
| 2 | 22894 | 19.8% |
| 3 | 12869 | 11.1% |
| 4 | 8770 | 7.6% |
| 5 | 5558 | 4.8% |
| 6 | 3905 | 3.4% |
| 7 | 1552 | 1.3% |
| 8 | 771 | 0.7% |
| 9 | 309 | 0.3% |
| 10 | 353 | 0.3% |
| Value | Count | Frequency (%) |
| 20 | 1 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 4 | < 0.1% |
| 17 | 11 | < 0.1% |
| 15 | 12 | < 0.1% |
| 14 | 6 | < 0.1% |
| 13 | 30 | < 0.1% |
| 12 | 60 | 0.1% |
| 11 | 73 | 0.1% |
| 10 | 353 |
product_weight_g
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 2197 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2113.9077 |
| Minimum | 0 |
|---|---|
| Maximum | 40425 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 125 |
| Q1 | 300 |
| median | 700 |
| Q3 | 1800 |
| 95-th percentile | 9850 |
| Maximum | 40425 |
| Range | 40425 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 3781.7549 |
|---|---|
| Coefficient of variation (CV) | 1.7889877 |
| Kurtosis | 16.034544 |
| Mean | 2113.9077 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 3.5806498 |
| Sum | 2.4438464 × 108 |
| Variance | 14301670 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 6815 | 5.9% |
| 150 | 5329 | 4.6% |
| 250 | 4671 | 4.0% |
| 300 | 4313 | 3.7% |
| 100 | 3571 | 3.1% |
| 400 | 3481 | 3.0% |
| 350 | 3211 | 2.8% |
| 500 | 2787 | 2.4% |
| 600 | 2778 | 2.4% |
| 700 | 2095 | 1.8% |
| Other values (2187) | 76557 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| 2 | 5 | < 0.1% |
| 25 | 3 | < 0.1% |
| 50 | 985 | |
| 53 | 2 | < 0.1% |
| 54 | 2 | < 0.1% |
| 55 | 2 | < 0.1% |
| 58 | 1 | < 0.1% |
| 60 | 9 | < 0.1% |
| 61 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 40425 | 3 | < 0.1% |
| 30000 | 296 | |
| 29800 | 1 | < 0.1% |
| 29750 | 1 | < 0.1% |
| 29700 | 4 | < 0.1% |
| 29600 | 5 | < 0.1% |
| 29500 | 2 | < 0.1% |
| 29250 | 1 | < 0.1% |
| 29150 | 1 | < 0.1% |
| 29100 | 1 | < 0.1% |
product_length_cm
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.307903 |
| Minimum | 7 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 18 |
| median | 25 |
| Q3 | 38 |
| 95-th percentile | 62 |
| Maximum | 105 |
| Range | 98 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 16.211108 |
|---|---|
| Coefficient of variation (CV) | 0.53488058 |
| Kurtosis | 3.6631229 |
| Mean | 30.307903 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.7425099 |
| Sum | 3503836 |
| Variance | 262.80004 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 17712 | 15.3% |
| 20 | 10603 | 9.2% |
| 30 | 7814 | 6.8% |
| 17 | 6126 | 5.3% |
| 18 | 5844 | 5.1% |
| 19 | 4845 | 4.2% |
| 25 | 4768 | 4.1% |
| 40 | 4238 | 3.7% |
| 22 | 3935 | 3.4% |
| 50 | 3091 | 2.7% |
| Other values (89) | 46632 |
| Value | Count | Frequency (%) |
| 7 | 32 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 8 | < 0.1% |
| 11 | 96 | 0.1% |
| 12 | 41 | < 0.1% |
| 13 | 60 | 0.1% |
| 14 | 137 | 0.1% |
| 15 | 212 | 0.2% |
| 16 | 17712 |
| Value | Count | Frequency (%) |
| 105 | 331 | |
| 104 | 30 | < 0.1% |
| 103 | 45 | < 0.1% |
| 102 | 60 | 0.1% |
| 101 | 108 | 0.1% |
| 100 | 424 | |
| 99 | 36 | < 0.1% |
| 98 | 50 | < 0.1% |
| 97 | 11 | < 0.1% |
| 96 | 8 | < 0.1% |
product_height_cm
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 102 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.638477 |
| Minimum | 2 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 13 |
| Q3 | 20 |
| 95-th percentile | 45 |
| Maximum | 105 |
| Range | 103 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 13.47357 |
|---|---|
| Coefficient of variation (CV) | 0.80978385 |
| Kurtosis | 7.2875078 |
| Mean | 16.638477 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.2431211 |
| Sum | 1923541 |
| Variance | 181.53708 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 10208 | 8.8% |
| 20 | 6796 | 5.9% |
| 15 | 6784 | 5.9% |
| 11 | 6309 | 5.5% |
| 12 | 6196 | 5.4% |
| 2 | 5097 | 4.4% |
| 4 | 4778 | 4.1% |
| 8 | 4773 | 4.1% |
| 16 | 4661 | 4.0% |
| 5 | 4636 | 4.0% |
| Other values (92) | 55370 |
| Value | Count | Frequency (%) |
| 2 | 5097 | |
| 3 | 2770 | 2.4% |
| 4 | 4778 | |
| 5 | 4636 | |
| 6 | 3511 | 3.0% |
| 7 | 4217 | |
| 8 | 4773 | |
| 9 | 3369 | 2.9% |
| 10 | 10208 | |
| 11 | 6309 |
| Value | Count | Frequency (%) |
| 105 | 137 | |
| 104 | 14 | < 0.1% |
| 103 | 49 | < 0.1% |
| 102 | 10 | < 0.1% |
| 100 | 42 | < 0.1% |
| 99 | 5 | < 0.1% |
| 98 | 3 | < 0.1% |
| 97 | 2 | < 0.1% |
| 96 | 8 | < 0.1% |
| 95 | 22 | < 0.1% |
product_width_cm
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 95 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.113167 |
| Minimum | 6 |
|---|---|
| Maximum | 118 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 15 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 45 |
| Maximum | 118 |
| Range | 112 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.755083 |
|---|---|
| Coefficient of variation (CV) | 0.50858817 |
| Kurtosis | 4.5531896 |
| Mean | 23.113167 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 1.7072171 |
| Sum | 2672067 |
| Variance | 138.18198 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 12447 | 10.8% |
| 11 | 10662 | 9.2% |
| 15 | 8964 | 7.8% |
| 16 | 8677 | 7.5% |
| 30 | 7880 | 6.8% |
| 12 | 5590 | 4.8% |
| 13 | 5412 | 4.7% |
| 14 | 4753 | 4.1% |
| 18 | 4122 | 3.6% |
| 40 | 4042 | 3.5% |
| Other values (85) | 43059 |
| Value | Count | Frequency (%) |
| 6 | 2 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 29 | < 0.1% |
| 9 | 51 | < 0.1% |
| 10 | 83 | 0.1% |
| 11 | 10662 | |
| 12 | 5590 | |
| 13 | 5412 | |
| 14 | 4753 | |
| 15 | 8964 |
| Value | Count | Frequency (%) |
| 118 | 7 | < 0.1% |
| 105 | 14 | < 0.1% |
| 104 | 1 | < 0.1% |
| 103 | 1 | < 0.1% |
| 102 | 2 | < 0.1% |
| 101 | 2 | < 0.1% |
| 100 | 43 | |
| 98 | 1 | < 0.1% |
| 97 | 1 | < 0.1% |
| 95 | 2 | < 0.1% |
seller_zip_code_prefix
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 2210 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24515.714 |
| Minimum | 1001 |
|---|---|
| Maximum | 99730 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1001 |
|---|---|
| 5-th percentile | 2969 |
| Q1 | 6429 |
| median | 13660 |
| Q3 | 28605 |
| 95-th percentile | 88316 |
| Maximum | 99730 |
| Range | 98729 |
| Interquartile range (IQR) | 22176 |
Descriptive statistics
| Standard deviation | 27636.641 |
|---|---|
| Coefficient of variation (CV) | 1.1273031 |
| Kurtosis | 0.9066511 |
| Mean | 24515.714 |
| Median Absolute Deviation (MAD) | 8132 |
| Skewness | 1.548043 |
| Sum | 2.8342372 × 109 |
| Variance | 7.6378392 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14940 | 8227 | 7.1% |
| 5849 | 2126 | 1.8% |
| 15025 | 2090 | 1.8% |
| 9015 | 1891 | 1.6% |
| 13405 | 1667 | 1.4% |
| 8577 | 1546 | 1.3% |
| 4782 | 1536 | 1.3% |
| 3204 | 1465 | 1.3% |
| 4160 | 1261 | 1.1% |
| 13232 | 1242 | 1.1% |
| Other values (2200) | 92558 |
| Value | Count | Frequency (%) |
| 1001 | 22 | < 0.1% |
| 1021 | 41 | < 0.1% |
| 1022 | 5 | < 0.1% |
| 1023 | 5 | < 0.1% |
| 1026 | 302 | |
| 1031 | 122 | |
| 1035 | 18 | < 0.1% |
| 1039 | 1 | < 0.1% |
| 1040 | 21 | < 0.1% |
| 1041 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 99730 | 12 | < 0.1% |
| 99700 | 2 | < 0.1% |
| 99670 | 1 | < 0.1% |
| 99500 | 61 | |
| 99300 | 2 | < 0.1% |
| 98975 | 19 | < 0.1% |
| 98920 | 1 | < 0.1% |
| 98910 | 14 | < 0.1% |
| 98803 | 65 | |
| 98780 | 4 | < 0.1% |
seller_city
Text
| Distinct | 604 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 40 |
|---|---|
| Median length | 31 |
| Mean length | 10.102155 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1167900 |
|---|---|
| Distinct characters | 63 |
| Distinct categories | 10 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 68 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Maua |
|---|---|
| 2nd row | Maua |
| 3rd row | Maua |
| 4th row | Maua |
| 5th row | Maua |
| Value | Count | Frequency (%) |
| sao | 35785 | 18.0% |
| paulo | 29092 | 14.6% |
| ibitinga | 8227 | 4.1% |
| rio | 5802 | 2.9% |
| preto | 5428 | 2.7% |
| do | 5420 | 2.7% |
| jose | 4035 | 2.0% |
| de | 3991 | 2.0% |
| santo | 3250 | 1.6% |
| andre | 3146 | 1.6% |
| Other values (634) | 94626 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 187194 | |
| o | 141616 | |
| i | 86927 | 7.4% |
| 83253 | 7.1% | |
| r | 66040 | 5.7% |
| e | 62563 | 5.4% |
| u | 60154 | 5.2% |
| l | 50605 | 4.3% |
| S | 46454 | 4.0% |
| P | 46176 | 4.0% |
| Other values (53) | 336918 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 883933 | |
| Uppercase Letter | 199507 | 17.1% |
| Space Separator | 83253 | 7.1% |
| Other Punctuation | 606 | 0.1% |
| Modifier Symbol | 365 | < 0.1% |
| Dash Punctuation | 164 | < 0.1% |
| Open Punctuation | 31 | < 0.1% |
| Close Punctuation | 31 | < 0.1% |
| Decimal Number | 8 | < 0.1% |
| Nonspacing Mark | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 187194 | |
| o | 141616 | |
| i | 86927 | |
| r | 66040 | 7.5% |
| e | 62563 | 7.1% |
| u | 60154 | 6.8% |
| l | 50605 | 5.7% |
| t | 44895 | 5.1% |
| n | 44171 | 5.0% |
| s | 27876 | 3.2% |
| Other values (14) | 111892 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 46454 | |
| P | 46176 | |
| C | 13499 | 6.8% |
| D | 13382 | 6.7% |
| I | 13117 | 6.6% |
| J | 10123 | 5.1% |
| R | 10071 | 5.0% |
| B | 9450 | 4.7% |
| A | 7153 | 3.6% |
| G | 6464 | 3.2% |
| Other values (12) | 23618 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 345 | |
| / | 138 | 22.8% |
| . | 74 | 12.2% |
| @ | 37 | 6.1% |
| \ | 6 | 1.0% |
| , | 6 | 1.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 2 | |
| 2 | 2 | |
| 5 | 2 | |
| 0 | 1 | |
| 8 | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 83253 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ´ | 365 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 164 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 31 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 31 |
Nonspacing Mark
| Value | Count | Frequency (%) |
| ̃ | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1083440 | |
| Common | 84458 | 7.2% |
| Inherited | 2 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 187194 | |
| o | 141616 | |
| i | 86927 | 8.0% |
| r | 66040 | 6.1% |
| e | 62563 | 5.8% |
| u | 60154 | 5.6% |
| l | 50605 | 4.7% |
| S | 46454 | 4.3% |
| P | 46176 | 4.3% |
| t | 44895 | 4.1% |
| Other values (36) | 290816 |
Common
| Value | Count | Frequency (%) |
| 83253 | ||
| ´ | 365 | 0.4% |
| ' | 345 | 0.4% |
| - | 164 | 0.2% |
| / | 138 | 0.2% |
| . | 74 | 0.1% |
| @ | 37 | < 0.1% |
| ( | 31 | < 0.1% |
| ) | 31 | < 0.1% |
| \ | 6 | < 0.1% |
| Other values (6) | 14 | < 0.1% |
Inherited
| Value | Count | Frequency (%) |
| ̃ | 2 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1167533 | |
| None | 365 | < 0.1% |
| Diacriticals | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 187194 | |
| o | 141616 | |
| i | 86927 | 7.4% |
| 83253 | 7.1% | |
| r | 66040 | 5.7% |
| e | 62563 | 5.4% |
| u | 60154 | 5.2% |
| l | 50605 | 4.3% |
| S | 46454 | 4.0% |
| P | 46176 | 4.0% |
| Other values (51) | 336551 |
None
| Value | Count | Frequency (%) |
| ´ | 365 |
Diacriticals
| Value | Count | Frequency (%) |
| ̃ | 2 |
seller_state
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| SP | |
|---|---|
| MG | |
| PR | |
| RJ | 4906 |
| SC | 4221 |
| Other values (18) | 6087 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 231218 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 82417 | |
| MG | 9014 | 7.8% |
| PR | 8964 | 7.8% |
| RJ | 4906 | 4.2% |
| SC | 4221 | 3.7% |
| RS | 2224 | 1.9% |
| DF | 937 | 0.8% |
| BA | 698 | 0.6% |
| GO | 537 | 0.5% |
| PE | 461 | 0.4% |
| Other values (13) | 1230 | 1.1% |
Length
| Value | Count | Frequency (%) |
| sp | 82417 | |
| mg | 9014 | 7.8% |
| pr | 8964 | 7.8% |
| rj | 4906 | 4.2% |
| sc | 4221 | 3.7% |
| rs | 2224 | 1.9% |
| df | 937 | 0.8% |
| ba | 698 | 0.6% |
| go | 537 | 0.5% |
| pe | 461 | 0.4% |
| Other values (13) | 1230 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 91902 | |
| S | 89305 | |
| R | 16164 | 7.0% |
| M | 9626 | 4.2% |
| G | 9551 | 4.1% |
| J | 4906 | 2.1% |
| C | 4325 | 1.9% |
| A | 1113 | 0.5% |
| E | 948 | 0.4% |
| D | 937 | 0.4% |
| Other values (6) | 2441 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 231218 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 91902 | |
| S | 89305 | |
| R | 16164 | 7.0% |
| M | 9626 | 4.2% |
| G | 9551 | 4.1% |
| J | 4906 | 2.1% |
| C | 4325 | 1.9% |
| A | 1113 | 0.5% |
| E | 948 | 0.4% |
| D | 937 | 0.4% |
| Other values (6) | 2441 | 1.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 231218 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 91902 | |
| S | 89305 | |
| R | 16164 | 7.0% |
| M | 9626 | 4.2% |
| G | 9551 | 4.1% |
| J | 4906 | 2.1% |
| C | 4325 | 1.9% |
| A | 1113 | 0.5% |
| E | 948 | 0.4% |
| D | 937 | 0.4% |
| Other values (6) | 2441 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 231218 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 91902 | |
| S | 89305 | |
| R | 16164 | 7.0% |
| M | 9626 | 4.2% |
| G | 9551 | 4.1% |
| J | 4906 | 2.1% |
| C | 4325 | 1.9% |
| A | 1113 | 0.5% |
| E | 948 | 0.4% |
| D | 937 | 0.4% |
| Other values (6) | 2441 | 1.1% |
| Distinct | 71 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
Length
| Max length | 39 |
|---|---|
| Median length | 31 |
| Mean length | 12.989949 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1501755 |
|---|---|
| Distinct characters | 44 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Housewares |
|---|---|
| 2nd row | Housewares |
| 3rd row | Housewares |
| 4th row | Housewares |
| 5th row | Housewares |
| Value | Count | Frequency (%) |
| bed | 11847 | 5.5% |
| table | 11847 | 5.5% |
| bath | 11847 | 5.5% |
| furniture | 11502 | 5.3% |
| accessories | 11423 | 5.3% |
| health | 9944 | 4.6% |
| beauty | 9944 | 4.6% |
| sports | 8942 | 4.1% |
| leisure | 8942 | 4.1% |
| decor | 8743 | 4.0% |
| Other values (99) | 111939 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 181025 | 12.1% |
| s | 121642 | 8.1% |
| o | 109159 | 7.3% |
| r | 104416 | 7.0% |
| t | 104286 | 6.9% |
| 101311 | 6.7% | |
| a | 81879 | 5.5% |
| u | 77400 | 5.2% |
| i | 60865 | 4.1% |
| c | 53224 | 3.5% |
| Other values (34) | 506548 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1183524 | |
| Uppercase Letter | 216624 | 14.4% |
| Space Separator | 101311 | 6.7% |
| Decimal Number | 296 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 181025 | |
| s | 121642 | |
| o | 109159 | |
| r | 104416 | |
| t | 104286 | |
| a | 81879 | 6.9% |
| u | 77400 | 6.5% |
| i | 60865 | 5.1% |
| c | 53224 | 4.5% |
| n | 48622 | 4.1% |
| Other values (13) | 241006 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 40475 | |
| T | 27868 | |
| A | 19718 | |
| H | 19617 | |
| S | 19408 | |
| C | 18732 | |
| F | 15461 | 7.1% |
| G | 13004 | 6.0% |
| L | 11240 | 5.2% |
| D | 9837 | 4.5% |
| Other values (9) | 21264 |
Space Separator
| Value | Count | Frequency (%) |
| 101311 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 296 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1400148 | |
| Common | 101607 | 6.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 181025 | 12.9% |
| s | 121642 | 8.7% |
| o | 109159 | 7.8% |
| r | 104416 | 7.5% |
| t | 104286 | 7.4% |
| a | 81879 | 5.8% |
| u | 77400 | 5.5% |
| i | 60865 | 4.3% |
| c | 53224 | 3.8% |
| n | 48622 | 3.5% |
| Other values (32) | 457630 |
Common
| Value | Count | Frequency (%) |
| 101311 | ||
| 2 | 296 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1501755 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 181025 | 12.1% |
| s | 121642 | 8.1% |
| o | 109159 | 7.3% |
| r | 104416 | 7.0% |
| t | 104286 | 6.9% |
| 101311 | 6.7% | |
| a | 81879 | 5.5% |
| u | 77400 | 5.2% |
| i | 60865 | 4.1% |
| c | 53224 | 3.5% |
| Other values (34) | 506548 |
review_response_time
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 210 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.5819443 |
| Minimum | 0 |
|---|---|
| Maximum | 518 |
| Zeros | 28066 |
| Zeros (%) | 24.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 518 |
| Range | 518 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 9.7851142 |
|---|---|
| Coefficient of variation (CV) | 3.7898239 |
| Kurtosis | 829.09885 |
| Mean | 2.5819443 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 24.09892 |
| Sum | 298496 |
| Variance | 95.74846 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 36120 | |
| 0 | 28066 | |
| 2 | 18555 | |
| 3 | 16464 | |
| 4 | 5350 | 4.6% |
| 5 | 3229 | 2.8% |
| 6 | 2050 | 1.8% |
| 7 | 1060 | 0.9% |
| 8 | 744 | 0.6% |
| 9 | 533 | 0.5% |
| Other values (200) | 3438 | 3.0% |
| Value | Count | Frequency (%) |
| 0 | 28066 | |
| 1 | 36120 | |
| 2 | 18555 | |
| 3 | 16464 | |
| 4 | 5350 | 4.6% |
| 5 | 3229 | 2.8% |
| 6 | 2050 | 1.8% |
| 7 | 1060 | 0.9% |
| 8 | 744 | 0.6% |
| 9 | 533 | 0.5% |
| Value | Count | Frequency (%) |
| 518 | 1 | < 0.1% |
| 512 | 1 | < 0.1% |
| 508 | 3 | |
| 471 | 1 | < 0.1% |
| 446 | 1 | < 0.1% |
| 433 | 1 | < 0.1% |
| 412 | 1 | < 0.1% |
| 411 | 1 | < 0.1% |
| 383 | 1 | < 0.1% |
| 367 | 1 | < 0.1% |
time_to_delivery
Real number (ℝ)
MISSING 
| Distinct | 143 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2400 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.976866 |
| Minimum | 0 |
|---|---|
| Maximum | 208 |
| Zeros | 19 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 6 |
| median | 10 |
| Q3 | 15 |
| 95-th percentile | 28 |
| Maximum | 208 |
| Range | 208 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 9.3622377 |
|---|---|
| Coefficient of variation (CV) | 0.78169346 |
| Kurtosis | 39.237666 |
| Mean | 11.976866 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 3.7914596 |
| Sum | 1355889 |
| Variance | 87.651495 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 8968 | 7.8% |
| 6 | 8011 | 6.9% |
| 8 | 7961 | 6.9% |
| 9 | 7090 | 6.1% |
| 5 | 6874 | 5.9% |
| 10 | 6710 | 5.8% |
| 11 | 6099 | 5.3% |
| 4 | 5712 | 4.9% |
| 12 | 5477 | 4.7% |
| 13 | 5140 | 4.4% |
| Other values (133) | 45167 |
| Value | Count | Frequency (%) |
| 0 | 19 | < 0.1% |
| 1 | 1856 | 1.6% |
| 2 | 3777 | |
| 3 | 4512 | |
| 4 | 5712 | |
| 5 | 6874 | |
| 6 | 8011 | |
| 7 | 8968 | |
| 8 | 7961 | |
| 9 | 7090 |
| Value | Count | Frequency (%) |
| 208 | 1 | < 0.1% |
| 195 | 1 | < 0.1% |
| 194 | 3 | |
| 191 | 1 | < 0.1% |
| 189 | 1 | < 0.1% |
| 188 | 1 | < 0.1% |
| 187 | 3 | |
| 186 | 1 | < 0.1% |
| 182 | 2 | |
| 181 | 1 | < 0.1% |
delivery_against_estimated
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 194 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2400 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -12.092351 |
| Minimum | -147 |
|---|---|
| Maximum | 188 |
| Zeros | 1468 |
| Zeros (%) | 1.3% |
| Negative | 104494 |
| Negative (%) | 90.4% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | -147 |
|---|---|
| 5-th percentile | -27 |
| Q1 | -17 |
| median | -13 |
| Q3 | -7 |
| 95-th percentile | 3 |
| Maximum | 188 |
| Range | 335 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 10.090815 |
|---|---|
| Coefficient of variation (CV) | -0.83447915 |
| Kurtosis | 27.60215 |
| Mean | -12.092351 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 1.8526615 |
| Sum | -1368963 |
| Variance | 101.82455 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -14 | 8425 | 7.3% |
| -13 | 6967 | 6.0% |
| -15 | 6291 | 5.4% |
| -7 | 5669 | 4.9% |
| -8 | 5605 | 4.8% |
| -9 | 5442 | 4.7% |
| -10 | 5434 | 4.7% |
| -11 | 5409 | 4.7% |
| -12 | 5333 | 4.6% |
| -16 | 4628 | 4.0% |
| Other values (184) | 54006 |
| Value | Count | Frequency (%) |
| -147 | 2 | |
| -140 | 1 | < 0.1% |
| -135 | 1 | < 0.1% |
| -124 | 2 | |
| -109 | 1 | < 0.1% |
| -84 | 1 | < 0.1% |
| -83 | 1 | < 0.1% |
| -78 | 4 | |
| -77 | 1 | < 0.1% |
| -76 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 188 | 1 | < 0.1% |
| 175 | 1 | < 0.1% |
| 167 | 1 | < 0.1% |
| 166 | 1 | < 0.1% |
| 165 | 1 | < 0.1% |
| 162 | 1 | < 0.1% |
| 161 | 5 | |
| 159 | 1 | < 0.1% |
| 155 | 3 | |
| 153 | 2 | < 0.1% |
product_volume_cm
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 4480 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15395.611 |
| Minimum | 168 |
|---|---|
| Maximum | 296208 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 168 |
|---|---|
| 5-th percentile | 816 |
| Q1 | 2860 |
| median | 6650 |
| Q3 | 18576 |
| 95-th percentile | 58500 |
| Maximum | 296208 |
| Range | 296040 |
| Interquartile range (IQR) | 15716 |
Descriptive statistics
| Standard deviation | 23618.937 |
|---|---|
| Coefficient of variation (CV) | 1.5341344 |
| Kurtosis | 25.356306 |
| Mean | 15395.611 |
| Median Absolute Deviation (MAD) | 4778 |
| Skewness | 4.0676347 |
| Sum | 1.7798558 × 109 |
| Variance | 5.5785418 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8000 | 2790 | 2.4% |
| 352 | 1801 | 1.6% |
| 19800 | 1305 | 1.1% |
| 4096 | 1183 | 1.0% |
| 816 | 1110 | 1.0% |
| 640 | 1103 | 1.0% |
| 27000 | 994 | 0.9% |
| 2560 | 967 | 0.8% |
| 4800 | 955 | 0.8% |
| 4500 | 935 | 0.8% |
| Other values (4470) | 102465 |
| Value | Count | Frequency (%) |
| 168 | 1 | < 0.1% |
| 288 | 1 | < 0.1% |
| 352 | 1801 | |
| 374 | 4 | < 0.1% |
| 378 | 1 | < 0.1% |
| 384 | 10 | < 0.1% |
| 396 | 12 | < 0.1% |
| 408 | 3 | < 0.1% |
| 416 | 5 | < 0.1% |
| 418 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 296208 | 1 | < 0.1% |
| 294000 | 4 | |
| 293706 | 1 | < 0.1% |
| 288000 | 7 | |
| 287980 | 4 | |
| 285138 | 1 | < 0.1% |
| 282750 | 3 | |
| 281232 | 1 | < 0.1% |
| 277550 | 2 | < 0.1% |
| 274625 | 1 | < 0.1% |
order_purchase_year
Categorical
HIGH CORRELATION 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| 2018 | |
|---|---|
| 2017 | |
| 2016 | 381 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 462436 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2017 |
|---|---|
| 2nd row | 2017 |
| 3rd row | 2017 |
| 4th row | 2017 |
| 5th row | 2017 |
Common Values
| Value | Count | Frequency (%) |
| 2018 | 62721 | |
| 2017 | 52507 | |
| 2016 | 381 | 0.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2018 | 62721 | |
| 2017 | 52507 | |
| 2016 | 381 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 115609 | |
| 0 | 115609 | |
| 1 | 115609 | |
| 8 | 62721 | |
| 7 | 52507 | |
| 6 | 381 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 462436 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 115609 | |
| 0 | 115609 | |
| 1 | 115609 | |
| 8 | 62721 | |
| 7 | 52507 | |
| 6 | 381 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 462436 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 115609 | |
| 0 | 115609 | |
| 1 | 115609 | |
| 8 | 62721 | |
| 7 | 52507 | |
| 6 | 381 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 462436 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 115609 | |
| 0 | 115609 | |
| 1 | 115609 | |
| 8 | 62721 | |
| 7 | 52507 | |
| 6 | 381 | 0.1% |
order_purchase_year_month
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 201759.96 |
| Minimum | 201609 |
|---|---|
| Maximum | 201809 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 201609 |
|---|---|
| 5-th percentile | 201703 |
| Q1 | 201709 |
| median | 201801 |
| Q3 | 201805 |
| 95-th percentile | 201808 |
| Maximum | 201809 |
| Range | 200 |
| Interquartile range (IQR) | 96 |
Descriptive statistics
| Standard deviation | 48.79949 |
|---|---|
| Coefficient of variation (CV) | 0.00024186906 |
| Kurtosis | -1.7282825 |
| Mean | 201759.96 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -0.23813442 |
| Sum | 2.3325267 × 1010 |
| Variance | 2381.3902 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 201711 | 8881 | 7.7% |
| 201803 | 8380 | 7.2% |
| 201801 | 8304 | 7.2% |
| 201805 | 8127 | 7.0% |
| 201804 | 8123 | 7.0% |
| 201802 | 7817 | 6.8% |
| 201808 | 7396 | 6.4% |
| 201806 | 7331 | 6.3% |
| 201807 | 7242 | 6.3% |
| 201712 | 6371 | 5.5% |
| Other values (14) | 37637 |
| Value | Count | Frequency (%) |
| 201609 | 3 | < 0.1% |
| 201610 | 377 | 0.3% |
| 201612 | 1 | < 0.1% |
| 201701 | 998 | 0.9% |
| 201702 | 1999 | |
| 201703 | 3109 | |
| 201704 | 2760 | |
| 201705 | 4300 | |
| 201706 | 3728 | |
| 201707 | 4773 |
| Value | Count | Frequency (%) |
| 201809 | 1 | < 0.1% |
| 201808 | 7396 | |
| 201807 | 7242 | |
| 201806 | 7331 | |
| 201805 | 8127 | |
| 201804 | 8123 | |
| 201803 | 8380 | |
| 201802 | 7817 | |
| 201801 | 8304 | |
| 201712 | 6371 |
order_purchase_hour
Real number (ℝ)
ZEROS 
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.76443 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 2835 |
| Zeros (%) | 2.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 11 |
| median | 15 |
| Q3 | 19 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.321909 |
|---|---|
| Coefficient of variation (CV) | 0.36045475 |
| Kurtosis | 0.19481186 |
| Mean | 14.76443 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.60132366 |
| Sum | 1706901 |
| Variance | 28.322715 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 7835 | 6.8% |
| 14 | 7776 | 6.7% |
| 11 | 7636 | 6.6% |
| 13 | 7569 | 6.5% |
| 15 | 7497 | 6.5% |
| 10 | 7200 | 6.2% |
| 17 | 7138 | 6.2% |
| 20 | 7127 | 6.2% |
| 21 | 7105 | 6.1% |
| 12 | 7056 | 6.1% |
| Other values (14) | 41670 |
| Value | Count | Frequency (%) |
| 0 | 2835 | |
| 1 | 1310 | 1.1% |
| 2 | 594 | 0.5% |
| 3 | 311 | 0.3% |
| 4 | 251 | 0.2% |
| 5 | 213 | 0.2% |
| 6 | 561 | 0.5% |
| 7 | 1396 | 1.2% |
| 8 | 3469 | |
| 9 | 5513 |
| Value | Count | Frequency (%) |
| 23 | 4811 | |
| 22 | 6810 | |
| 21 | 7105 | |
| 20 | 7127 | |
| 19 | 6858 | |
| 18 | 6738 | |
| 17 | 7138 | |
| 16 | 7835 | |
| 15 | 7497 | |
| 14 | 7776 |
order_purchase_month
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Aug | |
|---|---|
| May | |
| Jul | |
| Mar | |
| Jun | |
| Other values (7) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 346827 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Oct |
|---|---|
| 2nd row | Oct |
| 3rd row | Oct |
| 4th row | Aug |
| 5th row | Aug |
Common Values
| Value | Count | Frequency (%) |
| Aug | 12479 | |
| May | 12427 | |
| Jul | 12015 | |
| Mar | 11489 | |
| Jun | 11059 | |
| Apr | 10883 | |
| Feb | 9816 | |
| Jan | 9302 | |
| Nov | 8881 | |
| Dec | 6372 | |
| Other values (2) | 10886 |
Length
| Value | Count | Frequency (%) |
| aug | 12479 | |
| may | 12427 | |
| jul | 12015 | |
| mar | 11489 | |
| jun | 11059 | |
| apr | 10883 | |
| feb | 9816 | |
| jan | 9302 | |
| nov | 8881 | |
| dec | 6372 | |
| Other values (2) | 10886 |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 35553 | 10.3% |
| a | 33218 | 9.6% |
| J | 32376 | 9.3% |
| M | 23916 | 6.9% |
| A | 23362 | 6.7% |
| r | 22372 | 6.5% |
| e | 21206 | 6.1% |
| n | 20361 | 5.9% |
| p | 15901 | 4.6% |
| g | 12479 | 3.6% |
| Other values (12) | 106083 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 231218 | |
| Uppercase Letter | 115609 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| u | 35553 | |
| a | 33218 | |
| r | 22372 | |
| e | 21206 | |
| n | 20361 | |
| p | 15901 | |
| g | 12479 | 5.4% |
| y | 12427 | 5.4% |
| c | 12240 | 5.3% |
| l | 12015 | 5.2% |
| Other values (4) | 33446 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 32376 | |
| M | 23916 | |
| A | 23362 | |
| F | 9816 | 8.5% |
| N | 8881 | 7.7% |
| D | 6372 | 5.5% |
| O | 5868 | 5.1% |
| S | 5018 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 346827 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| u | 35553 | 10.3% |
| a | 33218 | 9.6% |
| J | 32376 | 9.3% |
| M | 23916 | 6.9% |
| A | 23362 | 6.7% |
| r | 22372 | 6.5% |
| e | 21206 | 6.1% |
| n | 20361 | 5.9% |
| p | 15901 | 4.6% |
| g | 12479 | 3.6% |
| Other values (12) | 106083 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 346827 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| u | 35553 | 10.3% |
| a | 33218 | 9.6% |
| J | 32376 | 9.3% |
| M | 23916 | 6.9% |
| A | 23362 | 6.7% |
| r | 22372 | 6.5% |
| e | 21206 | 6.1% |
| n | 20361 | 5.9% |
| p | 15901 | 4.6% |
| g | 12479 | 3.6% |
| Other values (12) | 106083 |
order_purchase_dayofweek
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Mon | |
|---|---|
| Tue | |
| Wed | |
| Thu | |
| Fri | |
| Other values (2) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 346827 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mon |
|---|---|
| 2nd row | Mon |
| 3rd row | Mon |
| 4th row | Tue |
| 5th row | Wed |
Common Values
| Value | Count | Frequency (%) |
| Mon | 18769 | |
| Tue | 18768 | |
| Wed | 18033 | |
| Thu | 17301 | |
| Fri | 16532 | |
| Sun | 13722 | |
| Sat | 12484 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| mon | 18769 | |
| tue | 18768 | |
| wed | 18033 | |
| thu | 17301 | |
| fri | 16532 | |
| sun | 13722 | |
| sat | 12484 |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 49791 | |
| e | 36801 | |
| T | 36069 | |
| n | 32491 | |
| S | 26206 | 7.6% |
| M | 18769 | 5.4% |
| o | 18769 | 5.4% |
| W | 18033 | 5.2% |
| d | 18033 | 5.2% |
| h | 17301 | 5.0% |
| Other values (5) | 74564 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 231218 | |
| Uppercase Letter | 115609 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| u | 49791 | |
| e | 36801 | |
| n | 32491 | |
| o | 18769 | 8.1% |
| d | 18033 | 7.8% |
| h | 17301 | 7.5% |
| r | 16532 | 7.1% |
| i | 16532 | 7.1% |
| a | 12484 | 5.4% |
| t | 12484 | 5.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 36069 | |
| S | 26206 | |
| M | 18769 | |
| W | 18033 | |
| F | 16532 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 346827 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| u | 49791 | |
| e | 36801 | |
| T | 36069 | |
| n | 32491 | |
| S | 26206 | 7.6% |
| M | 18769 | 5.4% |
| o | 18769 | 5.4% |
| W | 18033 | 5.2% |
| d | 18033 | 5.2% |
| h | 17301 | 5.0% |
| Other values (5) | 74564 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 346827 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| u | 49791 | |
| e | 36801 | |
| T | 36069 | |
| n | 32491 | |
| S | 26206 | 7.6% |
| M | 18769 | 5.4% |
| o | 18769 | 5.4% |
| W | 18033 | 5.2% |
| d | 18033 | 5.2% |
| h | 17301 | 5.0% |
| Other values (5) | 74564 |
| customer_state | customer_zip_code_prefix | delivery_against_estimated | freight_value | order_item_id | order_purchase_dayofweek | order_purchase_hour | order_purchase_month | order_purchase_year | order_purchase_year_month | order_status | payment_installments | payment_sequential | payment_type | payment_value | price | product_description_lenght | product_height_cm | product_length_cm | product_name_lenght | product_photos_qty | product_volume_cm | product_weight_g | product_width_cm | review_response_time | review_score | seller_state | seller_zip_code_prefix | time_to_delivery | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_state | 1.000 | -0.720 | 0.103 | -0.460 | 0.017 | 0.014 | -0.004 | 0.020 | 0.043 | 0.050 | 0.027 | -0.072 | 0.002 | 0.039 | -0.096 | -0.069 | -0.030 | -0.004 | 0.005 | -0.010 | -0.019 | 0.004 | -0.018 | 0.010 | -0.021 | 0.049 | 0.054 | -0.045 | -0.400 |
| customer_zip_code_prefix | -0.720 | 1.000 | -0.133 | 0.466 | -0.009 | 0.009 | 0.013 | 0.020 | 0.037 | -0.057 | 0.023 | 0.069 | -0.007 | 0.033 | 0.106 | 0.070 | 0.031 | 0.019 | 0.009 | 0.016 | 0.026 | 0.014 | 0.026 | -0.002 | 0.023 | 0.042 | 0.066 | 0.060 | 0.427 |
| delivery_against_estimated | 0.103 | -0.133 | 1.000 | -0.146 | -0.036 | 0.020 | 0.029 | 0.083 | 0.148 | 0.101 | 0.000 | -0.059 | -0.007 | 0.026 | -0.063 | -0.029 | 0.009 | -0.013 | -0.003 | 0.013 | 0.002 | -0.010 | -0.009 | -0.014 | -0.056 | 0.096 | 0.050 | -0.139 | 0.307 |
| freight_value | -0.460 | 0.466 | -0.146 | 1.000 | -0.056 | 0.008 | 0.007 | 0.017 | 0.028 | 0.047 | 0.016 | 0.190 | 0.016 | 0.010 | 0.424 | 0.435 | 0.117 | 0.284 | 0.282 | 0.033 | 0.010 | 0.369 | 0.448 | 0.273 | 0.017 | 0.015 | 0.048 | 0.256 | 0.420 |
| order_item_id | 0.017 | -0.009 | -0.036 | -0.056 | 1.000 | 0.008 | -0.013 | 0.009 | 0.005 | 0.002 | 0.003 | 0.060 | -0.007 | 0.021 | 0.257 | -0.114 | -0.032 | 0.019 | 0.008 | -0.022 | -0.064 | 0.015 | 0.001 | -0.003 | 0.018 | 0.041 | 0.000 | -0.012 | -0.022 |
| order_purchase_dayofweek | 0.014 | 0.009 | 0.020 | 0.008 | 0.008 | 1.000 | 0.002 | 0.047 | 0.025 | 0.012 | 0.007 | -0.016 | 0.004 | 0.035 | -0.002 | -0.003 | 0.000 | 0.003 | 0.002 | 0.007 | -0.002 | 0.002 | 0.000 | -0.002 | 0.012 | 0.012 | 0.010 | 0.001 | -0.040 |
| order_purchase_hour | -0.004 | 0.013 | 0.029 | 0.007 | -0.013 | 0.002 | 1.000 | 0.016 | 0.019 | -0.013 | 0.009 | 0.030 | 0.012 | 0.043 | -0.006 | 0.008 | -0.009 | 0.002 | 0.010 | -0.000 | 0.004 | 0.010 | 0.016 | 0.012 | -0.004 | 0.013 | 0.011 | -0.004 | -0.007 |
| order_purchase_month | 0.020 | 0.020 | 0.083 | 0.017 | 0.009 | 0.047 | 0.016 | 1.000 | 0.462 | -0.217 | 0.025 | 0.022 | 0.010 | 0.035 | 0.008 | 0.003 | -0.016 | 0.016 | 0.010 | -0.004 | -0.000 | 0.017 | 0.021 | 0.013 | -0.013 | 0.056 | 0.037 | 0.004 | 0.047 |
| order_purchase_year | 0.043 | 0.037 | 0.148 | 0.028 | 0.005 | 0.025 | 0.019 | 0.462 | 1.000 | 0.866 | 0.108 | -0.042 | -0.034 | 0.042 | 0.022 | 0.005 | 0.053 | -0.014 | -0.067 | 0.019 | -0.022 | -0.056 | -0.050 | -0.058 | -0.010 | 0.019 | 0.084 | -0.038 | -0.093 |
| order_purchase_year_month | 0.050 | -0.057 | 0.101 | 0.047 | 0.002 | 0.012 | -0.013 | -0.217 | 0.866 | 1.000 | 0.072 | -0.034 | -0.039 | 0.059 | 0.027 | 0.008 | 0.055 | -0.008 | -0.080 | 0.030 | -0.009 | -0.060 | -0.055 | -0.061 | -0.027 | 0.063 | 0.040 | -0.038 | -0.164 |
| order_status | 0.027 | 0.023 | 0.000 | 0.016 | 0.003 | 0.007 | 0.009 | 0.025 | 0.108 | 0.072 | 1.000 | 0.001 | 0.002 | 0.007 | 0.002 | 0.013 | 0.009 | 0.010 | 0.004 | -0.006 | 0.001 | 0.009 | 0.007 | 0.005 | -0.017 | 0.131 | 0.029 | 0.005 | -0.003 |
| payment_installments | -0.072 | 0.069 | -0.059 | 0.190 | 0.060 | -0.016 | 0.030 | 0.022 | -0.042 | -0.034 | 0.001 | 1.000 | -0.177 | 0.273 | 0.396 | 0.317 | 0.033 | 0.106 | 0.109 | 0.016 | -0.003 | 0.148 | 0.198 | 0.125 | 0.005 | 0.028 | 0.033 | 0.066 | 0.039 |
| payment_sequential | 0.002 | -0.007 | -0.007 | 0.016 | -0.007 | 0.004 | 0.012 | 0.010 | -0.034 | -0.039 | 0.002 | -0.177 | 1.000 | 0.229 | -0.214 | -0.005 | -0.013 | 0.011 | 0.032 | -0.004 | -0.004 | 0.027 | 0.028 | 0.026 | -0.014 | 0.012 | 0.016 | 0.006 | 0.009 |
| payment_type | 0.039 | 0.033 | 0.026 | 0.010 | 0.021 | 0.035 | 0.043 | 0.035 | 0.042 | 0.059 | 0.007 | 0.273 | 0.229 | 1.000 | -0.093 | 0.033 | -0.010 | 0.009 | 0.020 | -0.003 | -0.004 | 0.022 | 0.026 | 0.025 | -0.017 | 0.009 | 0.021 | 0.003 | -0.072 |
| payment_value | -0.096 | 0.106 | -0.063 | 0.424 | 0.257 | -0.002 | -0.006 | 0.008 | 0.022 | 0.027 | 0.002 | 0.396 | -0.214 | -0.093 | 1.000 | 0.790 | 0.169 | 0.306 | 0.231 | 0.024 | -0.012 | 0.351 | 0.452 | 0.234 | 0.024 | 0.028 | 0.037 | 0.163 | 0.123 |
| price | -0.069 | 0.070 | -0.029 | 0.435 | -0.114 | -0.003 | 0.008 | 0.003 | 0.005 | 0.008 | 0.013 | 0.317 | -0.005 | 0.033 | 0.790 | 1.000 | 0.211 | 0.328 | 0.268 | 0.042 | 0.028 | 0.391 | 0.515 | 0.273 | 0.008 | 0.012 | 0.053 | 0.179 | 0.113 |
| product_description_lenght | -0.030 | 0.031 | 0.009 | 0.117 | -0.032 | 0.000 | -0.009 | -0.016 | 0.053 | 0.055 | 0.009 | 0.033 | -0.013 | -0.010 | 0.169 | 0.211 | 1.000 | 0.134 | -0.020 | 0.073 | 0.111 | 0.036 | 0.095 | -0.081 | 0.002 | 0.015 | 0.112 | 0.002 | 0.007 |
| product_height_cm | -0.004 | 0.019 | -0.013 | 0.284 | 0.019 | 0.003 | 0.002 | 0.016 | -0.014 | -0.008 | 0.010 | 0.106 | 0.011 | 0.009 | 0.306 | 0.328 | 0.134 | 1.000 | 0.244 | -0.057 | -0.080 | 0.764 | 0.530 | 0.334 | 0.017 | 0.018 | 0.066 | 0.049 | 0.061 |
| product_length_cm | 0.005 | 0.009 | -0.003 | 0.282 | 0.008 | 0.002 | 0.010 | 0.010 | -0.067 | -0.080 | 0.004 | 0.109 | 0.032 | 0.020 | 0.231 | 0.268 | -0.020 | 0.244 | 1.000 | 0.060 | 0.005 | 0.735 | 0.618 | 0.631 | 0.018 | 0.018 | 0.085 | 0.062 | 0.078 |
| product_name_lenght | -0.010 | 0.016 | 0.013 | 0.033 | -0.022 | 0.007 | -0.000 | -0.004 | 0.019 | 0.030 | -0.006 | 0.016 | -0.004 | -0.003 | 0.024 | 0.042 | 0.073 | -0.057 | 0.060 | 1.000 | 0.163 | 0.022 | 0.076 | 0.066 | 0.008 | 0.013 | 0.070 | 0.009 | 0.001 |
| product_photos_qty | -0.019 | 0.026 | 0.002 | 0.010 | -0.064 | -0.002 | 0.004 | -0.000 | -0.022 | -0.009 | 0.001 | -0.003 | -0.004 | -0.004 | -0.012 | 0.028 | 0.111 | -0.080 | 0.005 | 0.163 | 1.000 | -0.031 | 0.003 | -0.015 | -0.007 | 0.016 | 0.040 | -0.078 | -0.029 |
| product_volume_cm | 0.004 | 0.014 | -0.010 | 0.369 | 0.015 | 0.002 | 0.010 | 0.017 | -0.056 | -0.060 | 0.009 | 0.148 | 0.027 | 0.022 | 0.351 | 0.391 | 0.036 | 0.764 | 0.735 | 0.022 | -0.031 | 1.000 | 0.767 | 0.762 | 0.024 | 0.019 | 0.035 | 0.073 | 0.081 |
| product_weight_g | -0.018 | 0.026 | -0.009 | 0.448 | 0.001 | 0.000 | 0.016 | 0.021 | -0.050 | -0.055 | 0.007 | 0.198 | 0.028 | 0.026 | 0.452 | 0.515 | 0.095 | 0.530 | 0.618 | 0.076 | 0.003 | 0.767 | 1.000 | 0.619 | 0.023 | 0.021 | 0.079 | 0.095 | 0.101 |
| product_width_cm | 0.010 | -0.002 | -0.014 | 0.273 | -0.003 | -0.002 | 0.012 | 0.013 | -0.058 | -0.061 | 0.005 | 0.125 | 0.026 | 0.025 | 0.234 | 0.273 | -0.081 | 0.334 | 0.631 | 0.066 | -0.015 | 0.762 | 0.619 | 1.000 | 0.019 | 0.013 | 0.058 | 0.075 | 0.043 |
| review_response_time | -0.021 | 0.023 | -0.056 | 0.017 | 0.018 | 0.012 | -0.004 | -0.013 | -0.010 | -0.027 | -0.017 | 0.005 | -0.014 | -0.017 | 0.024 | 0.008 | 0.002 | 0.017 | 0.018 | 0.008 | -0.007 | 0.024 | 0.023 | 0.019 | 1.000 | 0.004 | 0.011 | 0.017 | -0.015 |
| review_score | 0.049 | 0.042 | 0.096 | 0.015 | 0.041 | 0.012 | 0.013 | 0.056 | 0.019 | 0.063 | 0.131 | 0.028 | 0.012 | 0.009 | 0.028 | 0.012 | 0.015 | 0.018 | 0.018 | 0.013 | 0.016 | 0.019 | 0.021 | 0.013 | 0.004 | 1.000 | 0.023 | 0.017 | -0.221 |
| seller_state | 0.054 | 0.066 | 0.050 | 0.048 | 0.000 | 0.010 | 0.011 | 0.037 | 0.084 | 0.040 | 0.029 | 0.033 | 0.016 | 0.021 | 0.037 | 0.053 | 0.112 | 0.066 | 0.085 | 0.070 | 0.040 | 0.035 | 0.079 | 0.058 | 0.011 | 0.023 | 1.000 | -0.751 | -0.068 |
| seller_zip_code_prefix | -0.045 | 0.060 | -0.139 | 0.256 | -0.012 | 0.001 | -0.004 | 0.004 | -0.038 | -0.038 | 0.005 | 0.066 | 0.006 | 0.003 | 0.163 | 0.179 | 0.002 | 0.049 | 0.062 | 0.009 | -0.078 | 0.073 | 0.095 | 0.075 | 0.017 | 0.017 | -0.751 | 1.000 | 0.123 |
| time_to_delivery | -0.400 | 0.427 | 0.307 | 0.420 | -0.022 | -0.040 | -0.007 | 0.047 | -0.093 | -0.164 | -0.003 | 0.039 | 0.009 | -0.072 | 0.123 | 0.113 | 0.007 | 0.061 | 0.078 | 0.001 | -0.029 | 0.081 | 0.101 | 0.043 | -0.015 | -0.221 | -0.068 | 0.123 | 1.000 |
| order_id | customer_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | payment_sequential | payment_type | payment_installments | payment_value | review_id | review_score | review_comment_title | review_comment_message | review_creation_date | review_answer_timestamp | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | seller_zip_code_prefix | seller_city | seller_state | product_category_name_english | review_response_time | time_to_delivery | delivery_against_estimated | product_volume_cm | order_purchase_year | order_purchase_year_month | order_purchase_hour | order_purchase_month | order_purchase_dayofweek | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 10:56:33 | 2017-10-02 11:07:15 | 2017-10-04 19:55:00 | 2017-10-10 21:25:13 | 2017-10-18 | 7c396fd4830fd04220f754e42b4e5bff | 3149 | Sao Paulo | SP | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 11:07:15 | 29.99 | 8.72 | 1 | Credit Card | 1 | 18.12 | a54f0611adc9ed256b57ede6b6eb5114 | 4 | NaN | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. | 2017-10-11 | 2017-10-12 03:43:48 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 9350 | Maua | SP | Housewares | 1 | 8.0 | -8.0 | 1976.0 | 2017 | 201710 | 10 | Oct | Mon |
| 1 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 10:56:33 | 2017-10-02 11:07:15 | 2017-10-04 19:55:00 | 2017-10-10 21:25:13 | 2017-10-18 | 7c396fd4830fd04220f754e42b4e5bff | 3149 | Sao Paulo | SP | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 11:07:15 | 29.99 | 8.72 | 3 | Voucher | 1 | 2.00 | a54f0611adc9ed256b57ede6b6eb5114 | 4 | NaN | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. | 2017-10-11 | 2017-10-12 03:43:48 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 9350 | Maua | SP | Housewares | 1 | 8.0 | -8.0 | 1976.0 | 2017 | 201710 | 10 | Oct | Mon |
| 2 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 10:56:33 | 2017-10-02 11:07:15 | 2017-10-04 19:55:00 | 2017-10-10 21:25:13 | 2017-10-18 | 7c396fd4830fd04220f754e42b4e5bff | 3149 | Sao Paulo | SP | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 11:07:15 | 29.99 | 8.72 | 2 | Voucher | 1 | 18.59 | a54f0611adc9ed256b57ede6b6eb5114 | 4 | NaN | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. | 2017-10-11 | 2017-10-12 03:43:48 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 9350 | Maua | SP | Housewares | 1 | 8.0 | -8.0 | 1976.0 | 2017 | 201710 | 10 | Oct | Mon |
| 3 | 128e10d95713541c87cd1a2e48201934 | a20e8105f23924cd00833fd87daa0831 | delivered | 2017-08-15 18:29:31 | 2017-08-15 20:05:16 | 2017-08-17 15:28:33 | 2017-08-18 14:44:43 | 2017-08-28 | 3a51803cc0d012c3b5dc8b7528cb05f7 | 3366 | Sao Paulo | SP | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-08-21 20:05:16 | 29.99 | 7.78 | 1 | Credit Card | 3 | 37.77 | b46f1e34512b0f4c74a72398b03ca788 | 4 | NaN | Deveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente. | 2017-08-19 | 2017-08-20 15:16:36 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 9350 | Maua | SP | Housewares | 1 | 2.0 | -10.0 | 1976.0 | 2017 | 201708 | 18 | Aug | Tue |
| 4 | 0e7e841ddf8f8f2de2bad69267ecfbcf | 26c7ac168e1433912a51b924fbd34d34 | delivered | 2017-08-02 18:24:47 | 2017-08-02 18:43:15 | 2017-08-04 17:35:43 | 2017-08-07 18:30:01 | 2017-08-15 | ef0996a1a279c26e7ecbd737be23d235 | 2290 | Sao Paulo | SP | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-08-08 18:37:31 | 29.99 | 7.78 | 1 | Credit Card | 1 | 37.77 | dc90f19c2806f1abba9e72ad3c350073 | 5 | NaN | Só achei ela pequena pra seis xícaras ,mais é um bom produto\r\n | 2017-08-08 | 2017-08-08 23:26:23 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 9350 | Maua | SP | Housewares | 0 | 5.0 | -8.0 | 1976.0 | 2017 | 201708 | 18 | Aug | Wed |
| 5 | bfc39df4f36c3693ff3b63fcbea9e90a | 53904ddbea91e1e92b2b3f1d09a7af86 | delivered | 2017-10-23 23:26:46 | 2017-10-25 02:14:11 | 2017-10-27 16:48:46 | 2017-11-07 18:04:59 | 2017-11-13 | e781fdcc107d13d865fc7698711cc572 | 88032 | Florianopolis | SC | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-31 02:14:11 | 29.99 | 14.10 | 1 | Boleto | 1 | 44.09 | 1bafb430e498b939f258b9c9dbdff9b1 | 3 | NaN | NaN | 2017-11-08 | 2017-11-10 19:52:38 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 9350 | Maua | SP | Housewares | 2 | 14.0 | -6.0 | 1976.0 | 2017 | 201710 | 23 | Oct | Mon |
| 6 | 5f49f31e537f8f1a496454b48edbe34d | a7260a6ccba78544ccfaf43f920b7240 | delivered | 2017-08-24 11:31:28 | 2017-08-24 11:45:25 | 2017-08-25 14:17:55 | 2017-08-28 20:12:20 | 2017-09-14 | 7a1de9bde89aedca8c5fbad489c5571c | 1315 | Sao Paulo | SP | 2 | be03d93320192443b8fa24c0ca6ead98 | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-08-30 11:45:25 | 46.80 | 67.70 | 1 | Credit Card | 1 | 127.45 | 8899ca945efd951c97107b4966289227 | 1 | NaN | Prezados que porcaria de atendimento ao cliente não se consegue falar com um atendente, só uma máquina burra e ignorante.\r\nVocês não me enviaram o kit de vedação da cafeteira e o filtro e se só isso n | 2017-08-29 | 2017-08-30 02:26:02 | utilidades_domesticas | 59.0 | 189.0 | 3.0 | 775.0 | 16.0 | 16.0 | 13.0 | 9350 | Maua | SP | Housewares | 1 | 4.0 | -17.0 | 3328.0 | 2017 | 201708 | 11 | Aug | Thu |
| 7 | 1fa40f202d5d233b6491e976c557b822 | 50fd5707c28d0a64dc20d67f937dd9ba | delivered | 2017-09-23 22:11:10 | 2017-09-23 22:25:11 | 2017-09-26 17:27:54 | 2017-10-19 21:09:21 | 2017-11-13 | 35c6ec4630637b3ec0da6e587f245f83 | 69043 | Manaus | AM | 1 | 8415b1dae10d2dcb36beec370c6a90cd | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-09-27 22:25:11 | 28.90 | 21.15 | 1 | Credit Card | 1 | 50.05 | 4b70092fc12f2328972d5ff1022d87e9 | 4 | NaN | NaN | 2017-10-20 | 2017-10-23 04:13:41 | utilidades_domesticas | 59.0 | 322.0 | 5.0 | 600.0 | 24.0 | 5.0 | 18.0 | 9350 | Maua | SP | Housewares | 3 | 25.0 | -25.0 | 2160.0 | 2017 | 201709 | 22 | Sep | Sat |
| 8 | 41c045db2d1876be9f05cf4a787693b2 | a286f46d6e54cc0179bbb0ee07b0df5e | delivered | 2017-08-16 14:06:30 | 2017-08-16 14:55:20 | 2017-08-18 15:41:40 | 2017-08-21 15:05:13 | 2017-08-29 | 4e4fa2b85379e9db6dc59f873f0a9748 | 5640 | Sao Paulo | SP | 1 | 5e18248fc768bdb7fc69fd012068d109 | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-08-22 14:55:20 | 24.90 | 7.78 | 1 | Credit Card | 1 | 32.68 | b9e086024ceb0234e5950016497a4928 | 5 | NaN | NaN | 2017-08-22 | 2017-08-26 02:31:53 | utilidades_domesticas | 37.0 | 749.0 | 4.0 | 600.0 | 16.0 | 6.0 | 20.0 | 9350 | Maua | SP | Housewares | 4 | 5.0 | -8.0 | 1920.0 | 2017 | 201708 | 14 | Aug | Wed |
| 9 | a60241fca336b3f14485dff30a172cab | 2a3caad976ff659d519660a7c9357122 | delivered | 2018-07-27 22:05:26 | 2018-07-27 22:24:21 | 2018-07-30 09:15:00 | 2018-08-02 13:45:01 | 2018-08-20 | 0b7a92bbb834394fd894c370ba568278 | 88960 | Sombrio | SC | 1 | 883cea107372a7f07b5830904f74952d | 1c40343cc5d18c2d8248ac2f3366de34 | 2018-07-31 22:24:21 | 64.99 | 23.26 | 1 | Credit Card | 2 | 176.50 | abf7167b43e3978411cfaa0f77e5d21b | 3 | NaN | NaN | 2018-08-03 | 2018-08-03 21:50:00 | utilidades_domesticas | 53.0 | 220.0 | 1.0 | 1125.0 | 36.0 | 43.0 | 36.0 | 13482 | Limeira | SP | Housewares | 0 | 5.0 | -18.0 | 55728.0 | 2018 | 201807 | 22 | Jul | Fri |
| order_id | customer_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | payment_sequential | payment_type | payment_installments | payment_value | review_id | review_score | review_comment_title | review_comment_message | review_creation_date | review_answer_timestamp | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | seller_zip_code_prefix | seller_city | seller_state | product_category_name_english | review_response_time | time_to_delivery | delivery_against_estimated | product_volume_cm | order_purchase_year | order_purchase_year_month | order_purchase_hour | order_purchase_month | order_purchase_dayofweek | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 115599 | 28915ae2a90c218f0c2b7f8e0fb280e0 | 98a1b4f80dd0ccb7d1ae5a75ba5c904e | delivered | 2017-04-09 20:04:37 | 2017-04-11 03:45:26 | 2017-04-12 07:03:58 | 2017-04-18 09:53:40 | 2017-05-04 | bf5ed75fca98e8f79c49e9a5bf7690e1 | 13480 | Limeira | SP | 2 | e2dd0cb9b99517a86cbc9441cbb55348 | c731d18cea9bf687ffee82a241c25b11 | 2017-04-17 03:45:26 | 24.00 | 10.81 | 1 | Boleto | 1 | 63.25 | 79edb538f521d901d1167e50b4c4101f | 1 | NaN | faltou a forma e nao consigo entrar em contato, sempre ocupados | 2017-04-19 | 2017-04-22 20:23:39 | la_cuisine | 41.0 | 194.0 | 1.0 | 450.0 | 31.0 | 10.0 | 18.0 | 89701 | Concordia | SC | La Cuisine | 3 | 8.0 | -16.0 | 5580.0 | 2017 | 201704 | 20 | Apr | Sun |
| 115600 | f92d5bedc0cb67f0b4fb723b39af6a46 | 3505b6b5d1e198e50fcae66089393ffd | delivered | 2017-10-02 08:24:12 | 2017-10-02 08:35:11 | 2017-10-02 18:25:43 | 2017-10-07 00:03:49 | 2017-10-30 | 52fc783c029911295155492353866f9a | 31050 | Belo Horizonte | MG | 1 | d29534bc8c74cd3d91e0f175a5c9b366 | c731d18cea9bf687ffee82a241c25b11 | 2017-10-06 08:35:11 | 137.00 | 23.83 | 1 | Credit Card | 10 | 160.83 | f9a5034852e397e4c445480576c015b4 | 5 | NaN | NaN | 2017-10-08 | 2017-10-09 14:54:47 | la_cuisine | 59.0 | 748.0 | 1.0 | 1450.0 | 74.0 | 12.0 | 15.0 | 89701 | Concordia | SC | La Cuisine | 1 | 4.0 | -23.0 | 13320.0 | 2017 | 201710 | 8 | Oct | Mon |
| 115601 | 937592924b66482b823ee7ecd185d0ff | 0fbd856ba1d4961786fb54bd448eb7fe | delivered | 2018-03-31 19:17:43 | 2018-03-31 19:55:18 | 2018-04-02 19:10:46 | 2018-04-06 22:05:04 | 2018-04-18 | 96328ac15f58fbb232fe14b182103382 | 89675 | Vargem Bonita | SC | 1 | 0c800efe70e04ffcc3b266946e3e4826 | c731d18cea9bf687ffee82a241c25b11 | 2018-04-05 19:55:18 | 389.00 | 37.70 | 1 | Credit Card | 8 | 426.70 | 45c02db2f81c1968c58f08d46694213d | 4 | NaN | NaN | 2018-04-07 | 2018-04-18 13:28:14 | la_cuisine | 59.0 | 284.0 | 2.0 | 12500.0 | 83.0 | 21.0 | 43.0 | 89701 | Concordia | SC | La Cuisine | 11 | 6.0 | -12.0 | 74949.0 | 2018 | 201803 | 19 | Mar | Sat |
| 115602 | 4cbf1cc60a2d1704a70e11ee8be1510a | 406c8e1382162dc6bef214e0c01fc297 | delivered | 2018-01-01 17:03:13 | 2018-01-01 17:11:48 | 2018-01-02 15:58:13 | 2018-01-10 13:45:30 | 2018-01-30 | 9b8844d7cceb1277e6508cce966e4a09 | 6767 | Taboao Da Serra | SP | 1 | 2365562e74dd46f5e99cdc696c504cea | c731d18cea9bf687ffee82a241c25b11 | 2018-01-05 17:11:18 | 112.00 | 18.03 | 1 | Credit Card | 2 | 130.03 | d2ab760b550d788a438048f6fca52aef | 5 | NaN | NaN | 2018-01-11 | 2018-01-12 09:53:28 | la_cuisine | 49.0 | 554.0 | 1.0 | 1750.0 | 95.0 | 9.0 | 37.0 | 89701 | Concordia | SC | La Cuisine | 1 | 8.0 | -20.0 | 31635.0 | 2018 | 201801 | 17 | Jan | Mon |
| 115603 | fbd9022ebf9271e1952ca884a972d1bd | 3e46b833c6f5d7827700b8ef99db2e08 | delivered | 2017-07-22 17:55:13 | 2017-07-22 18:10:09 | 2017-07-24 18:28:01 | 2017-07-27 19:03:29 | 2017-08-11 | 578035514ad8238fa724f24b4aabc1df | 88705 | Tubarao | SC | 1 | 2365562e74dd46f5e99cdc696c504cea | c731d18cea9bf687ffee82a241c25b11 | 2017-07-27 18:10:09 | 105.00 | 14.60 | 1 | Credit Card | 1 | 119.60 | ac24486e719028c654916b3aa2419a50 | 5 | NaN | NaN | 2017-07-28 | 2017-07-29 14:03:58 | la_cuisine | 49.0 | 554.0 | 1.0 | 1750.0 | 95.0 | 9.0 | 37.0 | 89701 | Concordia | SC | La Cuisine | 1 | 5.0 | -15.0 | 31635.0 | 2017 | 201707 | 17 | Jul | Sat |
| 115604 | 30b0ea32347476f4b427daf62e09a5bb | 9d9cfbce48737214f23bf294daf3c6f7 | delivered | 2017-08-12 19:20:39 | 2017-08-12 19:30:17 | 2017-08-14 18:26:28 | 2017-08-17 18:28:10 | 2017-09-05 | 6c861f46d09c560422f6ba6b33c017fe | 9371 | Maua | SP | 1 | b52e7c92200ed9874e77bc09b5ed4d40 | c731d18cea9bf687ffee82a241c25b11 | 2017-08-17 19:30:17 | 174.00 | 39.06 | 1 | Credit Card | 5 | 213.06 | fdbbec4b750e768ac12c054acd906d1d | 5 | NaN | NaN | 2017-08-18 | 2017-08-19 20:09:58 | la_cuisine | 57.0 | 232.0 | 1.0 | 7600.0 | 55.0 | 15.0 | 55.0 | 89701 | Concordia | SC | La Cuisine | 1 | 4.0 | -19.0 | 45375.0 | 2017 | 201708 | 19 | Aug | Sat |
| 115605 | 1ce0acf125f1bcd636276dd213363196 | d11524bb77c28efad04e4467eac8a660 | delivered | 2017-07-31 18:10:29 | 2017-07-31 18:25:20 | 2017-08-02 18:22:30 | 2017-08-09 20:38:07 | 2017-08-28 | 6968d41eb700f1ea39424e04b854bf7e | 30130 | Belo Horizonte | MG | 1 | cc9e875c2df286dbed83efe01191162c | c731d18cea9bf687ffee82a241c25b11 | 2017-08-04 18:25:20 | 129.00 | 26.18 | 1 | Credit Card | 2 | 55.18 | 4dc7a70acb9d9eeeb1db4e74f88b2e9b | 5 | NaN | Recomendo | 2017-08-10 | 2017-08-13 17:29:51 | la_cuisine | 57.0 | 429.0 | 1.0 | 2700.0 | 85.0 | 7.0 | 40.0 | 89701 | Concordia | SC | La Cuisine | 3 | 9.0 | -19.0 | 23800.0 | 2017 | 201707 | 18 | Jul | Mon |
| 115606 | 1ce0acf125f1bcd636276dd213363196 | d11524bb77c28efad04e4467eac8a660 | delivered | 2017-07-31 18:10:29 | 2017-07-31 18:25:20 | 2017-08-02 18:22:30 | 2017-08-09 20:38:07 | 2017-08-28 | 6968d41eb700f1ea39424e04b854bf7e | 30130 | Belo Horizonte | MG | 1 | cc9e875c2df286dbed83efe01191162c | c731d18cea9bf687ffee82a241c25b11 | 2017-08-04 18:25:20 | 129.00 | 26.18 | 2 | Voucher | 1 | 100.00 | 4dc7a70acb9d9eeeb1db4e74f88b2e9b | 5 | NaN | Recomendo | 2017-08-10 | 2017-08-13 17:29:51 | la_cuisine | 57.0 | 429.0 | 1.0 | 2700.0 | 85.0 | 7.0 | 40.0 | 89701 | Concordia | SC | La Cuisine | 3 | 9.0 | -19.0 | 23800.0 | 2017 | 201707 | 18 | Jul | Mon |
| 115607 | c72888e51a36defb7b5d49201fcbccf7 | c3cd86c3cbac654f8558a8286ba93c1c | delivered | 2017-07-11 10:45:57 | 2017-07-11 10:55:14 | 2017-07-11 19:14:48 | 2017-07-19 17:27:43 | 2017-08-04 | d8b80a0bd7560fab10e804f36d99fe33 | 90220 | Porto Alegre | RS | 1 | 724c49c346d2979339d366fa59ce49de | 3078096983cf766a32a06257648502d1 | 2017-07-17 10:55:14 | 119.99 | 27.16 | 1 | Credit Card | 1 | 47.15 | 80d6f91212fb5216bfc90feddee75581 | 5 | NaN | Recebi corretamente o produto no prazo estipulado. | 2017-07-20 | 2017-07-21 13:13:33 | la_cuisine | 33.0 | 532.0 | 1.0 | 3600.0 | 30.0 | 30.0 | 30.0 | 13720 | Scao Jose Do Rio Pardo | SP | La Cuisine | 1 | 8.0 | -16.0 | 27000.0 | 2017 | 201707 | 10 | Jul | Tue |
| 115608 | c72888e51a36defb7b5d49201fcbccf7 | c3cd86c3cbac654f8558a8286ba93c1c | delivered | 2017-07-11 10:45:57 | 2017-07-11 10:55:14 | 2017-07-11 19:14:48 | 2017-07-19 17:27:43 | 2017-08-04 | d8b80a0bd7560fab10e804f36d99fe33 | 90220 | Porto Alegre | RS | 1 | 724c49c346d2979339d366fa59ce49de | 3078096983cf766a32a06257648502d1 | 2017-07-17 10:55:14 | 119.99 | 27.16 | 2 | Voucher | 1 | 100.00 | 80d6f91212fb5216bfc90feddee75581 | 5 | NaN | Recebi corretamente o produto no prazo estipulado. | 2017-07-20 | 2017-07-21 13:13:33 | la_cuisine | 33.0 | 532.0 | 1.0 | 3600.0 | 30.0 | 30.0 | 30.0 | 13720 | Scao Jose Do Rio Pardo | SP | La Cuisine | 1 | 8.0 | -16.0 | 27000.0 | 2017 | 201707 | 10 | Jul | Tue |